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.

N1901LBerry Darrel · Camden, TNBuilt 1976 · S/N TH-754 N1902DBoeing Co · Berkeley, MOBuilt 1998 · S/N UE327 N190AWCsi 135 Division LLC · Albuquerque, NMBuilt 1999 · S/N UE-382 N190BABering Air Inc · Nome, AKBuilt 2020 · S/N 208B5611 N190BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N LW-345 N190BHJourney Aviation LLC · Brookland, ARBuilt 1981 · S/N BB-907 N190EBKar King LLC · Huntington, WVBuilt 2005 · S/N BB-1905 N190EFTriple E Farms LLC · Pasco, WABuilt 1985 · S/N LJ-1122 N190FDOreh Aircraft LLC · New Braunfels, TXBuilt 1980 · S/N LA-42 N190GCMonarch Enterprises Inc · Kirkland, WABuilt 1970 · S/N 285 N190JKAnswers Collective Inc · Hamilton, OHBuilt 1995 · S/N 560-0303 N190JPClearwater Midstream LLC · Lubbock, TXBuilt 1981 · S/N LA-158 N190KRegistered aircraftBuilt 1994 · S/N 560-0279 N190MCN560mc LLC · Raleigh, NCBuilt 2007 · S/N 560-0769 N190NCCf Holdings LLC · Hernando, MSBuilt 1982 · S/N LA193 N190PASandy Wings LLC · Wilmington, DES/N 320 N190RLCamair Leasing LLC · Granbury, TXBuilt 1972 · S/N LW-1 N190RSBas Part Sales LLC · Greeley, COBuilt 1977 · S/N TH-804 N190SSJ&H Kramer Inc · Redwood City, CABuilt 1992 · S/N LJ1298 N190TTAcme Jet LLC · Dover, DEBuilt 1982 · S/N BB-1005 N190XTNextant Aerospace LLC · Cleveland, OHBuilt 1984 · S/N LJ-1066 N1910AKms Air LLC · West Bend, WIBuilt 2005 · S/N 258711 N1910RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 208B5891 N1911JD M C Aviation LLC · Jennings, LABuilt 1971 · S/N E-298 N1912LRegistered aircraftBuilt 1976 · S/N E-866 N191AWCsi 135 Division LLC · Albuquerque, NMBuilt 1996 · S/N UE-251 N191CSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N UE-392 N191JHJack Henry And Associates Inc · Monett, MOBuilt 1982 · S/N E-2042 N191JKN191jk LLC · Brunswick, GABuilt 1982 · S/N E-1943 N191JRLocke-Lane Aviation LLC · Statesville, NCBuilt 1975 · S/N LW144 N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720 N191NMcm Leasing LLC · Pittsfield, MABuilt 2003 · S/N 334 N191PJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1990 · S/N 258203 N191VFN191vf LLC · Birmingham, ALBuilt 2002 · S/N 560-0627 N1923TTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N FL-1266 N1926A1926a LLC · Auburn, ALBuilt 1981 · S/N BB-922 N192ALAlm Holdings Delaware 6 LLC · Wilmington, DES/N 208B0385 N192FDepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N FL-770 N192GCMonarch Enterprises Inc · Kirkland, WABuilt 2008 · S/N 208B2026 N193JCWt 1 Interests LLC · Houston, TXBuilt 1991 · S/N 650-0199 N193RAWilmington Trust Co Trustee · Wilmington, DEBuilt 1993 · S/N FL105 N193SETitan Aviation LLC · Wilmington, DES/N 560-0229 N193SGSunshine Sky Aviation LLC · Doral, FLBuilt 2003 · S/N 258627 N1949SDovetail Aviation LLC · Wilmington, NCBuilt 1977 · S/N E-1011 N194MGSdw Aviation LLC · Albany, GABuilt 1999 · S/N 525-0357 N194SAPennair LLC · Katy, TXBuilt 1993 · S/N 560-0238 N194SMSurveying And Mapping LLC · Austin, TXBuilt 2019 · S/N 208B5546 N194TRExecutive Air Taxi Corp · Bismarck, NDBuilt 1983 · S/N BB-1146 N194UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26892 N194YYTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1989 · S/N FA-194

Back to AD 2006-16-18 R1