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.

N1950XArgyll Aviation II LLC · Kiefer, OKBuilt 1998 · S/N E3174 N1952Wti Aviation LLC · Wilmington, DEBuilt 1984 · S/N E-2176 N1953KKms Air LLC · West Bend, WIBuilt 2006 · S/N 258775 N1957NAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2024 · S/N 525-1182 N195ALJmds Lift LLC · Helena, MTFirst renewal noticeBuilt 1986 · S/N FA-102 N195AWCsi 135 Division LLC · Albuquerque, NMBuilt 1993 · S/N UE-128 N195CAJp Aero LLC · Dayton, OHBuilt 2003 · S/N FL-364 N195FLInternational Air Services Inc Trustee · Carson City, NVBuilt 1991 · S/N E-2619 N195GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-195 N195MFHat*Trick Holdings LLC · Buchanan, MIBuilt 1995 · S/N 525-0110 N195PASandy Wings LLC · Wilmington, DEBuilt 1983 · S/N 399 N195UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26899 N1964ARex Air LLC · Madisonville, LABuilt 1993 · S/N E-2822 N1966GAir Services International Charters LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 2001 · S/N 208B0927 N1967GGary Ventures Inc · Denver, COBuilt 2003 · S/N 5600641 N1969JRegistered aircraftBuilt 1994 · S/N 560-0277 N196FSTechnical Education Services Inc · Virginia Beach, VABuilt 1978 · S/N 421C0501 N196GCZuni LLC · Kirkland, WABuilt 2012 · S/N 208B2353 N196PASandy Wings LLC · Wilmington, DES/N 321 N196SCChickasaw Transport LLC · Santa Rosa Beach, FLBuilt 1996 · S/N BB-1525 N196ZZTj Air Holdings Inc Trustee · Wilmington, DES/N FA-196 N1970NDaniel Arthur D · Fishtail, MTBuilt 1969 · S/N E-186 N1974DN822js LLC · Norcross, GABuilt 1973 · S/N E-493 N1975ADayspring Aviation LLC · Bend, ORBuilt 1976 · S/N E-860 N1979Whitley Jason · Southlake, TXBuilt 1979 · S/N E-1568 N197DHHintz Donald C · Punta Gorda, FLBuilt 1997 · S/N E-3084 N197MJSkyview LLC · Wilmington, DES/N 197 N197RDean Clay · Cleveland, TXBuilt 1974 · S/N E520 N197SCCharlie Ninety Alpha LLC · Searcy, ARBuilt 1997 · S/N LJ-1490 N197UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26901 N1983WTailwinds LLC · Houston, TXBuilt 1988 · S/N E-2423 N1983XSouthern Airways Pacific LLC · Addison, TXBuilt 2003 · S/N 208B1013 N1989BN455jw LLC · Missoula, MTBuilt 1988 · S/N 217 N198AGAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2015 · S/N FL-1005 N198AWCsi Aviation Inc · Albuquerque, NMBuilt 1997 · S/N UE293 N198BArkla Aviation LLC · Farmerville, LABuilt 2000 · S/N TH-1936 N198PABartowjets LLC · Wilmington, DEBuilt 1986 · S/N 482 N198STaylor Quarter Circle T Ranch Llp · Taylor, NEBuilt 1978 · S/N E-1161 N199BCAirco King LLC · Wichita Falls, TXBuilt 1980 · S/N LA-30 N199CGGuardian Flight LLC · Lewisville, TXBuilt 2002 · S/N LJ-1661 N199DWAeon62 Holdings LLC · Plano, TXBuilt 1980 · S/N LW-338 N199MHGsg Aviation LLC · Fort Lauderdale, FLBuilt 1981 · S/N BB-855 N199PLDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-167 N199YMicnic King Air LLC · Port Richey, FLBuilt 1991 · S/N FL66 N19CAPoulton Bruce A · Fremont, CABuilt 1994 · S/N E-2877 N19DPMonterey Bay LLC · Atlanta, GABuilt 1993 · S/N 525-0040 N19EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N UE326 N19HUStoneway Aviation LLC · Prospect, KYBuilt 1991 · S/N 560-0135 N19LLDsr-Cherokee 180 LLC · Dallas, TXBuilt 1970 · S/N E-224 N19MCFlying B Holdings LLC · Ozona, TXBuilt 1988 · S/N FA-167

Back to AD 2006-16-18 R1