Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N810RDKing Air N810rd LLC · Bluffton, SCS/N LJ-1691 N810SSNgo Aviation LLC · Lafayette, LABuilt 1996 · S/N 525-0137 N810TARhoades Aviation Inc · Honolulu, HIBuilt 1975 · S/N 21116 N810TCSanborn Map Co Inc · Colorado Springs, COBuilt 1984 · S/N FA-002 N8111MDcf30 Corp · Doral, FLBuilt 1991 · S/N TH-1617 N8116NStingray Aviation LLC · Visalia, CABuilt 1991 · S/N FL-58 N8118KRegistered aircraftN-number assigned (import), not yet registeredS/N 33722 N811CWJ & H Aviation LLC · Lumpkin, GABuilt 1982 · S/N TH-1351 N811DKucheck Alan · Yucca Valley, CAS/N 500A-1256-80 N811DZDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31916 N811FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N FL-811 N811JLSolera Aviation LLC · Bozeman, MTBuilt 2021 · S/N 525-1090 N811KCTwa International Inc · Cheyenne, WYFirst renewal noticeBuilt 1979 · S/N LJ-869 N811LAWild Blue Skies LLC · Galena, OHBuilt 1993 · S/N E-2820 N811LSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 208B2212 N811NATm Aero LLC · Riverview, FLS/N 421C-1082 N811NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31079 N811PBMathis Timber LLC · Corinth, MSFirst renewal noticeBuilt 1972 · S/N TH-194 N811PGH&S Aircraft LLC · Lewes, DEBuilt 1984 · S/N 421C1413 N811SH1212012 LLC · Omaha, NEBuilt 1991 · S/N 560-0120 N811TBM Goss LLC · Vidalia, GABuilt 1990 · S/N TH-1576 N811TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1986 · S/N 23538 N811VGTwo Oceans 555 LLC · Fort Myers, FLBuilt 1979 · S/N 5510017 N811WEWarmont Company · Midland, TXBuilt 2011 · S/N 560-0811 N811WFWill Fire Holdings LLC · Dublin, GABuilt 2016 · S/N FL-1061 N8123NReplica Sales & Engineering Inc · Muscatine, IABuilt 1992 · S/N TH-1671 N8124LEliza Air Inc · New Orleans, LABuilt 1991 · S/N TH-1623 N8126LTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N FL-726 N812BGGallo Robert L · Palm Beach Garden, FLS/N E-2960 N812CRWayne Halfway House Inc · Waynesboro, TNS/N LJ-1695 N812DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31923 N812ELLambard Luke G · Bossier City, LABuilt 1975 · S/N E-774 N812GBTrinity Logistics Holdings LLC · Saint Johns, FLBuilt 1980 · S/N LA-72 N812HACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1985 · S/N S550-0054 N812JCLfgsgb LLC · Greenville, SCBuilt 1992 · S/N TH-1676 N812LLH800 Vi LLC · Stuart, FLBuilt 2003 · S/N 258620 N812NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33520 N812SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 258683 N812SHCamp Logistics LLC · Scottsdale, AZBuilt 1990 · S/N 560-0049 N812TTBranched Oak Charter LLC · Rising City, NEBuilt 1985 · S/N BB-1207 N812WPMerrell Clayton Lee · Amarillo, TXBuilt 1975 · S/N E-669 N8131HCataldo Michael · Hingham, MAS/N E-2755 N8135NAlbion Air Enterprises LLC · Albion, NEBuilt 1991 · S/N E-2642 N8136ERunyon Rodney D · Portland, TNBuilt 1991 · S/N E-2614 N8136RDreamstead Recreational Vehicles LLC · Kalispell, MTBuilt 1974 · S/N E-612 N8137PFlying Daze · Batavia, OHBuilt 1991 · S/N E-2653 N8138RDavenport Clifford M · Bonita, CABuilt 1974 · S/N E-587 N813BLSarma Aviation LLC · Fort Wayne, INBuilt 1978 · S/N BE-55 N813DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31925 N813FMKevin Parra Aviation LLC · San Diego, CABuilt 2015 · S/N 525-0884

Back to AD 2006-16-18 R1