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.

N8096UWhitty Aviation LLC · Rocklin, CABuilt 1993 · S/N LJ-1326 N8099HHerber Aircraft Service Inc · El Segundo, CABuilt 1992 · S/N E-2743 N809BLBoluyt John A Trustee · Lowell, MIBuilt 1981 · S/N E-1890 N809DMAir Reldan Inc · Slidell, LABuilt 1980 · S/N LW-334 N809DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31915 N809HCCourson Oil And Gas Inc · Perryton, TXS/N BB-1864 N809LLLandlocked Company LLC · Dover, DES/N 809 N809NHSears Larry · Gainesville, TXBuilt 1993 · S/N E-2818 N809NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33519 N809PSP & P Air LLC · Wilmington, DEBuilt 1978 · S/N BB-339 N809SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 20800081 N809SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 208B5725 N809TARhoades Aviation Inc · Honolulu, HIBuilt 1987 · S/N 23796 N809TSMedic Choppers LLC · Springdale, ARS/N D-809 N80AB80ab Group LLC · Wichita Falls, TXBuilt 1992 · S/N 560-0169 N80BGBatesville Aircraft LLC · Batesville, ARBuilt 1980 · S/N TH-1174 N80BTCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N LW-148 N80BZMiddle Tennessee State University · Murfreesboro, TNS/N FA-117 N80CPBf Air LLC · Panama City, FLBuilt 1977 · S/N BB-263 N80DCJacobs Richard B · South Dartmouth, MABuilt 1980 · S/N E-1726 N80FMTrns Solutions LLC · Lewes, DEBuilt 1984 · S/N 650-0057 N80GEWin Win Aviation Inc · Wake Forest, NCBuilt 1996 · S/N 208B0585 N80HAC&J Michel Aviation LLC · Lexington, KYBuilt 1980 · S/N 5010159 N80JFIsr Aviation LLC · Wilmington, DEBuilt 1993 · S/N 208B0352 N80JHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 560-0327 N80KLLiberty Leasing Vii LLC · Melbourne, FLBuilt 2007 · S/N 20800411 N80LGTru North Aviation LLC · Ironwood, MIBuilt 1975 · S/N 421C0021 N80PGPhoenix Air Group Inc · Cartersville, GABuilt 1976 · S/N 063 N80PKN80080pk LLC · Stuart, FLBuilt 1999 · S/N 258442 N80RCHupp Dana A · Granger, INBuilt 1976 · S/N E943 N80RDRobert Wiplinger LLC · Inver Grove, MNBuilt 1986 · S/N 20800085 N80RWW & G Aviation Inc · College Station, TXBuilt 1981 · S/N E-1992 N80SLTechnical Systems Management Corp · Cudjoe Key, FLBuilt 1979 · S/N 501-0294 N80WGCapital Holdings 80 LLC · Lake Havasu City, AZS/N E-3631 N80WMAt Aero LLC · Wilmington, DES/N BB-863 N80YBYork Aircraft Equities LLC · York, PABuilt 2024 · S/N 525-1183 N80YZZimerbort Jacov · Melville, NYBuilt 1979 · S/N E-1417 N81Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-16 N81025Bank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N FL-725 N8106JAd Alta Aviation LLC · Flower Mound, TXBuilt 1991 · S/N E-2591 N8107VDavila Gilberto · Quebradillas, PRBuilt 1991 · S/N E-2595 N810ACJackson J Stuart · Bonner, MTBuilt 1998 · S/N E-3153 N810AFJt Acquisitions LLC · Nashville, TNBuilt 2002 · S/N 258589 N810BEChrysler Aviation Inc · Van Nuys, CABuilt 1990 · S/N 560-0066 N810DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31922 N810DTWiley Aviation LLC · Kalispell, MTBuilt 1994 · S/N TH-1738 N810ECState Of Tennessee · Nashville, TNBuilt 2024 · S/N FL-1343 N810KBOrange Skies LLC · New Carrollton, MDS/N 257118 N810NHCedar Medical Consultants LLC · Alexandria, LAS/N E-2819 N810NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 33207

Back to AD 2006-16-18 R1