AD 52-03-01

Registered aircraft · 308

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:52-03-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:52-03-01')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N20615Kretsinger Steven H Trustee · Eugene, ORBuilt 1938 · S/N 3407N20619Smith Happy E · Rogersville, TNBuilt 1939 · S/N 300N20628Lipsett Rory · Lancaster, PABuilt 1939 · S/N R9-403N20631Levine James David · Mentor, OHBuilt 1938 · S/N 3358N20632Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1939 · S/N R9-405N20641Gonzales Donald M · Columbia Station, OHBuilt 1938 · S/N 3318N224DBBongiovanni Joseph T · Ocala, FLBuilt 1946 · S/N R46264N2302Schmidt Aaron B · Auburn, ALBuilt 1939 · S/N 304N232EThomson Scott R · Street SomersetS/N R40-425N24FMCoon Robert E · Warrenville, ILBuilt 1970 · S/N HB690N25327Neal Sean Edward · Freehold, NYBuilt 1950 · S/N W40-113N25329Hargreaves William A · Lovettsville, VAS/N R40-404N25392Walker Joseph E · Hoodsport, WAS/N R40-409N255YWeeks Kermit A · Dolk City, FLBuilt 1972 · S/N T-2N2639Neuman Allen D · Sanger, TXBuilt 1938 · S/N 3315N26AGVintage Aero Inc · Brandon, FLBuilt 1941 · S/N FV724N26AHOklahoma Warbird Aviation LLC · Oklahoma City, OKS/N 907N282FCClassic Toy Barn LLC · Central Islip, NYS/N R46261N28690Fortin Russell J · Linden, MIS/N W41A-111N302Alaska Bush Leasing LLC · Anchorage, AKBuilt 1943 · S/N 1294N306WAllen Cheryl L · Hilltop Lakes, TXBuilt 1939 · S/N R9-407N306YDaly Clifford T · Garden City, NYS/N H003N3184MMorgan Richard D · Belton, TXBuilt 1943 · S/N 7403AEN318YFreeman Heritage Collection LLC · Kingsbury, TXBuilt 1976 · S/N 6829-D-367N31GLDanielle Michael G Trustee · Cottage Grove, ORBuilt 1996 · S/N 7007-K-996N323CJKuhnert Michael C · Topping, VABuilt 1943 · S/N T43-5778N33176Hauck Dennis J · Crawfordsville, INBuilt 1944 · S/N 10424-AEN336ESamuilov Vladimir A · Sound Beach, NYS/N 2934N33QYanks Air Museum · Baldwin Park, CAS/N 1398N363AEEichhorn Adrian A · Mclean, VABuilt 1945 · S/N T43-7208N38992Johnson Bros Aviation LLC · Sweetwater, TXBuilt 1944 · S/N 9014AEN390HKlubichek Janet C · Winnemucca, NVBuilt 1972 · S/N 67717-F-331N39681Price Donald N · Houston, TXS/N FV133N40265American Airpower Heritage Flying Museum · Dallas, TXBuilt 1941 · S/N T41562N4119AManning Philip J · Melbourne, FLBuilt 1941 · S/N T41-1048N414UIronworks Air LLC · Rogers, MNBuilt 1945 · S/N 1427N439EWImlay Ryan E · Livermore, CABuilt 1943 · S/N T43-4498N444MTriple 4 Mike LLC · Crystal Bay, NVS/N 1411N46199Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1944 · S/N T43-7274N46389Boggs Wayne G · Tampa, FLBuilt 1943 · S/N T43-5311N464BCCaldwell Collection Inc · Oklahoma City, OKBuilt 1942 · S/N 253N46502Simply Living LLC · Fort Myers, FLBuilt 1943 · S/N 1995N4652VBlanton David L · Valley Center, KSBuilt 2025 · S/N RXW-1N46876American Airpower Heritage Flying Museum · Dallas, TXBuilt 1942 · S/N T421957N46881Riffle Brian W · Auburn, WABuilt 1943 · S/N T435426N47015Mohr Charles F · Buffalo, NYRegistration revokedBuilt 1943 · S/N 4435792N47054Elrod Brent W · Cashion, OKBuilt 1940 · S/N R40-402N47117Bauer Aviation LLC · Reese, MIBuilt 1943 · S/N T43-5397N47154Williamson Rolla Charles Jr · East Falmouth, MARegistration revokedBuilt 1943 · S/N 7283AEN47158Jorgensen Jeremiah D · Elizabethtown, KYBuilt 1943 · S/N T43-7428
Back to AD 52-03-01