Registered aircraft · 108,428

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

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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number

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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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.

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:2007-04-19-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N183LELeading Edge Flight Academy LLC · Bend, ORBuilt 2007 · S/N 4183 N183MACarpe Diem Montana Inc · Columbus, MTBuilt 2012 · S/N 3163 N183MERegistration Pending · Page, AZRegistration pendingBuilt 2000 · S/N 20608107 N183NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11083 N183PSHc02 LLC · Vero Beach, FLBuilt 2014 · S/N 2328 N183QDrajesk Jeffrey F · Fish Creek, WIBuilt 1965 · S/N D-7883 N183RLea Brandon Wayne Sr · Bartlett, TNBuilt 1957 · S/N D-5155 N183RFBero Tim · Vernonia, ORBuilt 2002 · S/N 183R N183RLJe Air LLC · Bayamon, PRBuilt 1973 · S/N 17261654 N183SBBarnes Steven D · Santa Rosa, CAFirst renewal noticeBuilt 2005 · S/N 001 N183SKHill Vicki · Saint Joseph, LABuilt 1977 · S/N 18052824 N183SVQuality Feed Grains Inc · Harrison, ARS/N 05-301031 N183TYEuroaviation Inc Trustee · KematenBuilt 2019 · S/N 14319 N183VBRegistration Pending · Palm City, FLRegistration pendingBuilt 1977 · S/N E-1097 N183WOertel William R · Norco, CABuilt 1984 · S/N 1446 N18402Ohlhauser Devin · Bismarck, NDBuilt 1977 · S/N E-1117 N18403Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1120 N1840GJulicher Mark R · Bulverde, TXBuilt 1968 · S/N 79 N1840VUnited States Air Force Owner · Apo, APBuilt 1974 · S/N 17263767 N1840WPutz Aeroplanes LLC · Bryan, TXBuilt 1973 · S/N D-9431 N18413Cook Brian D · La Vernia, TXBuilt 1977 · S/N CE-736 N18414US Aviation Training Solutions · Titusville, FLBuilt 2005 · S/N 0226 N1841AJohnson Kevin L · Canyon, TXBuilt 1952 · S/N 18-1735 N1841RPatton Ronald V II · Keizer, ORBuilt 1974 · S/N 18502556 N1841WN1841w LLC · Plant City, FLBuilt 1973 · S/N CE-437 N1841XBoland Thomas · Pewaukee, WIBuilt 1964 · S/N 18255941 N18429Withers John Justin · Paris, TXS/N CE-937 N1842EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12176 N1842JAgthe Thilo Claus · Highlands, NJBuilt 1968 · S/N 28-24277 N1842SFry William A · Willmar, MNBuilt 1973 · S/N 414-0433 N1842TPowell Gary · South Jordan, UTBuilt 1971 · S/N 28-7125273 N1842WNorthwoods Aviation · Marion, IAS/N CE-438 N1842XRichey Perry A · Willow, AKBuilt 1964 · S/N 18255942 N1842ZVermont Skydiving Adventures Inc · Bristol, VTBuilt 1962 · S/N 205-0042 N1843FJordan Jay · Centre, ALBuilt 1966 · S/N 21058743 N1843GWincar Air LLC · Doniphan, NEBuilt 1968 · S/N 78 N1843JMerlina Michael · North Reading, MABuilt 1968 · S/N 28-24278 N1843LRegistered aircraftS/N TJ-65 N1843PAdams James · Quinlan, TXBuilt 1955 · S/N 22-2623 N1843TWalko Timothy A · Florence, MAS/N 28-7105117 N1843ZVacek George T Jr · Anchorage, AKBuilt 1962 · S/N 205-0043 N18448Redd Horse LLC · Wilmington, DEBuilt 1977 · S/N TC-2087 N1844GTwenty One Miles LLC · Woodland Hills, CABuilt 1968 · S/N 84 N1844JSwanberg Brian M · Federal Way, WABuilt 1968 · S/N 28-24279 N1844LRao Enterprises LLC · Brighton, MIBuilt 1976 · S/N D-9880 N1844XSmith James E · Cuba, MOBuilt 1964 · S/N 18255944 N1844ZN1844z LLC · Hillsboro, ORBuilt 1962 · S/N 205-0044 N18456Hewson Robert A · Santa Barbara, CABuilt 1977 · S/N E-1131 N18457Colwell Arthur R · Magnolia, TXBuilt 1977 · S/N E-1133 N1845FJones Sandy Ray · Williamsburg, NMS/N 21058745

Back to AD 2007-04-19 R1