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.

N1538VEvergreen Flying Club Inc · Medina, WABuilt 1974 · S/N 17263651 N1538XStaton Justin · Kemah, TXBuilt 1975 · S/N 28R-7535315 N15391Lyon Anthony R · Bethesda, MDBuilt 1972 · S/N 28-7305068 N15392Dgm Aviation LLC · Hurricane, WVBuilt 1972 · S/N 28-7305069 N15396Nomann Arnold H · Viroqua, WIBuilt 1972 · S/N 28-7310041 N15397Boisvert Thomas Michael · Sonoita, AZBuilt 1972 · S/N 28-7310042 N1539CMarincus Benjamin Marius · Medford, ORBuilt 2003 · S/N 0545 N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040 N1539MN1539m LLC · Kalispell, MTBuilt 1975 · S/N 18264366 N1539V39 Victor Aviation Inc · Macomb, ILBuilt 1989 · S/N E-2469 N1539WM P W D Inc · Saint Charles, ILBuilt 1972 · S/N E-326 N1539ZGelber Lisa G Trustee · Tujunga, CABuilt 1961 · S/N D-6866 N153AAHorn Jack E · Erie, COBuilt 2007 · S/N 2386 N153ACN153ac LLC · Eldon, MOBuilt 1993 · S/N 702-93 N153AMMedford Daniel E · Lakeville, MNS/N 17702222 N153BAGeorge Tim D · Cleburne, TXBuilt 2010 · S/N 880211 N153BCMeierotto Jeff T · Two Rivers, AKBuilt 2011 · S/N BC-1 N153BDM & M Farms · Fowler, KSS/N 80939 N153CHarless Richard K · Battle Mountain, NVBuilt 1998 · S/N 1415 N153FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281774 N153GReese Paul D · Elkview, WVBuilt 2007 · S/N 1039-2007 N153GBBackovich George C · Pine Grove, CABuilt 2018 · S/N 1739 N153GHHealey David A · Hammondsport, NYBuilt 1966 · S/N 660602 N153GMFly High Aviation LLC · Melrose Park, ILBuilt 1992 · S/N 5266 N153JPPew John R · Casa Grande, AZBuilt 2007 · S/N 053 N153JRRs Helicopters Inc · Lake Wales, FLBuilt 1953 · S/N 3753 N153LACarolina Mobile Storage LLC · Prestonsburg, KYBuilt 2013 · S/N 13422 N153LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842196 N153MBaker Thomas J · Oxford, MDBuilt 2011 · S/N 82655 N153MCHollingshead Keith · Clarksboro, NJBuilt 2004 · S/N 60128 N153MKThomas Paul · Falls Church, VABuilt 1984 · S/N 32-8406009 N153PCRegistered aircraftBuilt 2009 · S/N 172S10956 N153PPBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 18266340 N153RJones Jeremy R · Lampasas, TXS/N 35020 N153RAWeiner Marc H · Hoboken, NJBuilt 2001 · S/N 1311-2001 N153REEwen Russell L · Georgetown, TXBuilt 1999 · S/N 20467 N153SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4147 N153SPRegistered aircraftN-number assigned, not yet registeredS/N CJ-24 N153TAAmerican Eagle 1 LLC · Kimberling City, MOBuilt 2001 · S/N 18281053 N153TKChapman Thomas K · Weatherford, TXS/N 44 N153WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1995 · S/N 0152 N153WWWineland Wayne J · Independence, ORBuilt 2008 · S/N 72678 N154Nystrom Timothy L · Foreston, MNBuilt 1974 · S/N 28-7405097 N15401Adkins Jerome B · Northridge, CABuilt 1972 · S/N 28-7325057 N15402Swaz Aviation LLC · Queen Creek, AZBuilt 1972 · S/N 28-7325058 N15405Kurin Kerry · Tulsa, OKBuilt 1972 · S/N 28-7305070 N1540CBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 1518 N1540JGray Caleb · Henderson, NVBuilt 1967 · S/N 28-23942 N1540MClark Robert L Jr · Johnston, IABuilt 1975 · S/N 18264367 N1540RPolar Tigers Inc · North Oaks, MNBuilt 1975 · S/N AA5B-0040

Back to AD 2007-04-19 R1