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.

N8190GSchubert Jackie E Jr · Jamestown, TNS/N E-2658 N8191KSummerfields Animal Hospital Pllc · Fort Worth, TXBuilt 1991 · S/N E-2662 N8192RStarr Aviation LLC · Birmingham, ALBuilt 1974 · S/N E-598 N8195JJani-King Int'L Inc · Addison, TXBuilt 1993 · S/N E-2789 N8198MGokul LLC · Landrum, SCBuilt 1993 · S/N E-2787 N819BBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 208B5544 N819DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31930 N819EEVaquero Skies LLC · El Paso, TXBuilt 1997 · S/N FL-187 N819EKMaisaka LLC · Fremont, CABuilt 1984 · S/N S550-0009 N819EXPreserve Air LLC · Honolulu, HIBuilt 2006 · S/N 347 N819KMSahalee Air LLC · Covington, WABuilt 2006 · S/N 208B1215 N819LAMukherjee Jason S Trustee · Simi Valley, CABuilt 1994 · S/N E-2869 N819LBBowles Jeffrey D · Fitchburg, WIBuilt 1977 · S/N E-1126 N819MHC&W Logistics LLC · Garden City, KSFirst renewal noticeBuilt 1977 · S/N LJ-735 N819NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31083 N819RARonald Jinsky LLC · Beloit, WIBuilt 1978 · S/N 421C0522 N819SHSilverhawk Aviation Inc · Lincoln, NEBuilt 2002 · S/N 560-0604 N81CLGlassman Aaron · Virginia Beach, VABuilt 1981 · S/N TH-1296 N81CP78cl Aviation LLC · Ogden, UTBuilt 2007 · S/N 525-0633 N81DDJdj Transport LLC · Wilmington, DEBuilt 1980 · S/N TH-1212 N81DLLewis Donald C · Winters, CABuilt 1977 · S/N E-1156 N81DRCommonwealth Aviation Service Inc DBA · Richmond, VABuilt 1978 · S/N TH-971 N81EBTcm Air Inc · Fort Smith, ARS/N 501-0003 N81ETRussell Timothy Lee Jr · Saint Petersburg, FLBuilt 1998 · S/N BB1625 N81FGBrandis Robert DBA · Taylorville, ILS/N E-2424 N81HBMinard Patricia J · Cheney, KSBuilt 1981 · S/N E-1902 N81HCSmith Ronald Shane · Peachtree City, GABuilt 1990 · S/N TH-1600 N81HPFly Buys Too LLC · Wilmington, DEBuilt 1973 · S/N LW-72 N81LPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 421C-1083 N81PAPennsylvania Dept Of Transportation · New Cumberland, PABuilt 2019 · S/N FL-1196 N81RDPapaco LLC · Green Cove Springs, FLS/N 421C0291 N81RJHughes Frank H · Hackberry, LABuilt 1979 · S/N E-1617 N81SUMedary Aviation LLC · Brookings, SDBuilt 1989 · S/N LJ-1194 N81TEMichaud Nathan M · Willows, CABuilt 1980 · S/N TH-1195 N81TFA P A C LLC · Berlin, NJBuilt 1980 · S/N BB-750 N81TLC S & P Rocky Mountain Inc · Cheyenne, WYS/N BB-959 N81UCRegistration Pending · Orchard Park, NYRegistration pendingBuilt 1971 · S/N TH-142 N8201Omega Air Inc · Selma, TXS/N 48201 N8201ETigre Air LLC · Missoula, MTBuilt 1993 · S/N E-2777 N8204MBlue Sky Flying Club LLC · Granger, IABuilt 1991 · S/N E-2667 N8205Omega Air Inc · Selma, TXS/N 48205 N8209Omega Air Inc · Selma, TXS/N 48209 N8209ARocky Top Real Estate Investments LLC · Paola, KSBuilt 1993 · S/N E-2781 N820BHVertical Air Inc · Deland, FLBuilt 1989 · S/N 208B0153 N820BRSkywood Aviation LLC · Wayne, NJBuilt 1996 · S/N E-3011 N820DLEs&E Aviation LLC · Greensboro, NCS/N BB-1820 N820DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31931 N820FEFederal Express Corporation · Memphis, TNBuilt 1992 · S/N 208B0111 N820GHMcdavitt Edward T · Sugar Land, TXBuilt 1994 · S/N E-2870 N820JTRegistered aircraftBuilt 2015 · S/N 525-0870

Back to AD 2006-16-18 R1