OpenAirDocs.org
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.

N1010WLawlor Stephen M · Saint Joseph, MOBuilt 1946 · S/N R46-253N101PEDemarco Eugene J · New Orleans, LABuilt 1944 · S/N 1386N103JCAmerican Air Power Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N FC-119N1094MSartori Luciano · Windermere, FLBuilt 1943 · S/N T43-4470N1110RCalifornia Flight Museum · Coronado, CABuilt 1942 · S/N T42-3872N11161Gonzales Donald M · Columbia Station, OHBuilt 1946 · S/N T43-4549N112BWStout Mary J · High Point, NCS/N 5-176N1132N1941 Historical Aircraft Group Museum DBA · Geneseo, NYBuilt 1942 · S/N FC-27N1175NHistoric Flights Foundation Corp · Kokomo, INS/N FT-635N119ECMid Atlantic Air Museum · Reading, PABuilt 1940 · S/N T40-308N11CMDay Leslie · San Diego, CABuilt 1949 · S/N 9884AEN11DOwls Head Transportation Museum · Owls Head, MES/N D2N12156Rhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1975 · S/N 17-D-7517N127MPKelly Michael P · Coldwater, MIBuilt 1943 · S/N T43-5846N128PTOwens Wilbur · Rch Palos Vrd, CABuilt 1942 · S/N FT735N129PTTsi Holdco Inc · Virginia Beach, VABuilt 1943 · S/N T43-7230N13322Corbin Roger T · New Braunfels, TXBuilt 1943 · S/N 10539N1340VClaire Aviation · Wilmington, DEBuilt 1941 · S/N 1228N13AAnderson Aviation Inc · Anderson, SCBuilt 1946 · S/N 149N141RCompton Steven J · Anchorage, AKBuilt 1944 · S/N 1378N144SLBank Of Utah Trustee · Salt Lake City, UTS/N 1215N14988Penney John C Trustee · Evergreen, COBuilt 1943 · S/N 952N1594VTennis Gayland L · Bath, MIS/N T434547N1595Omeara Jeffrey Ryan · Bainbridge Island, WABuilt 1939 · S/N R9-427N1595VBlocher Steven W Jr · Moscow, IDS/N 1319N164WRMcbride Robert W Jr · Cedar Park, TXBuilt 1968 · S/N 3N16682Planes Of Fame Air Museum · Chino, CABuilt 1936 · S/N 3107N16812Moericke Eric A · Waupaca, WIS/N 3113N16818Jett Edward C Jr · Bloomfield, KYBuilt 1936 · S/N 3119N16858Schneider Gregory M · Bridger, MTBuilt 1937 · S/N 3138N16872White Theodore F · Willow, AKBuilt 1937 · S/N 3201N16901Bishop Harold W · Bonners Ferry, IDBuilt 1937 · S/N 3210N16902Bouslog Todd Charles · Noblesville, INS/N 3211N16904Jackson John Douglas · Hollister, CABuilt 1937 · S/N 3213N17511Lumley William B · Delray Beach, FLBuilt 1958 · S/N 175-213N1777Harrington Mark A · West Milford, NJBuilt 1942 · S/N T42-3629N18681Waldron Robert J · Webster, MNBuilt 1939 · S/N 3324N18682Collins John P · El Cajon, CABuilt 1939 · S/N R9-424N18688Pfou Michael G · Princeton, MNBuilt 1939 · S/N W-101N18695Champaign Aviation Museum · Urbana, OHBuilt 1939 · S/N W213N18852Lafayette Foundation Inc · Fort Lupton, COBuilt 1979 · S/N 20N19126Seifert Richard E · Troy, MOBuilt 1937 · S/N 3221N19128Golden Age Air Museum · Bethel, PAS/N 3223N19184Gonzales Donald M · Columbia Station, OHBuilt 1938 · S/N 3507N1918PTsi Holdco Inc · Virginia Beach, VABuilt 1991 · S/N 6880N193ARCorsicana Field Aviation Heritage Foundation · Rice, TXBuilt 1943 · S/N T43-7155N1941NLone Star Flight Museum · Houston, TXBuilt 1941 · S/N T41-1184N19GPWegmueller Daniel E · Monroe, WIS/N T421844N19PTMoore George C Sr · Fincastle, VAS/N T41-572N19RHMartin James L · South Bend, INBuilt 1943 · S/N 7583AE
Back to AD 52-03-01