Skip to content

Registered aircraft · 81,720

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

N15372Hollingshead Terry L · Flint, MIBuilt 1972 · S/N 28-7325050 N15373Johnson Brant T · Collinsville, OKS/N 28-7325051 N15374Smith William L · Supply, NCS/N 28-7325052 N15376Brown William D Jr · Mount Pleasant, TXBuilt 1972 · S/N 28-7305065 N15377Johnson Matthew · Biglerville, PABuilt 1972 · S/N 28-7305066 N15378Ketcham Jesse E · Aguanga, CABuilt 1973 · S/N 28-7305067 N15379Huyler John C · Shreveport, LABuilt 1972 · S/N 28R-7335053 N1537JYearta Philip T · Bono, ARS/N 28-23938 N1537XSale Reported · Milton, FLSale reportedBuilt 1975 · S/N 28-7515418 N15380Miller Aviation Group LLC · Coon Rapids, MNBuilt 1972 · S/N 28R-7335054 N15383Nevill Donald L · Clare, MIBuilt 1972 · S/N 32-7300006 N15388Smith John-Michael L · Austin, TXBuilt 1972 · S/N 28-7325054 N1538PWassmus Justin A · Riley, MIS/N 22-2415 N1538RAction Aerospace LLC · Bluffton, SCBuilt 1975 · S/N AA5B-0038 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 N1539AHall Mark R · New Smyrna Beach, FLBuilt 1951 · S/N 20-735 N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040 N1539HAve Maria LLC · Batesville, INBuilt 1975 · S/N 177RG0713 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 N153JRRs Helicopters Inc · Lake Wales, FLBuilt 1953 · S/N 3753 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 N153MTMiller Nathan · Irwin, OHBuilt 1978 · S/N 15282694 N153PCRegistered aircraftBuilt 2009 · S/N 172S10956 N153RAWeiner Marc H · Hoboken, NJBuilt 2001 · S/N 1311-2001 N153REEwen Russell L · Georgetown, TXBuilt 1999 · S/N 20467 N153RJG B Acro Inc · Grandville, MIBuilt 2008 · S/N 71152 N153RTThomas Rod M · Gooding, IDS/N 71935 N153SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4147 N153SKWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281770 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

Back to AD 81-18-04 R2