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.

N454GCUniversity Of South Carolina · Columbia, SCBuilt 2012 · S/N FL-789 N454GQSwifton Aviation Inc · Swifton, ARBuilt 1980 · S/N LA-39 N454JDickey Michael W · Fredericksburg, TXBuilt 1979 · S/N E-1571 N454LFJamm Aviation Inc · Columbus, OHBuilt 1998 · S/N FL-209 N454MAMarv Air LLC · Chattanooga, TNBuilt 1998 · S/N 525-0286 N454SFPa1 208b-0797 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 208B-0797 N454TBDepartment Of Public Safety Of The State Of Texas · Austin, TXBuilt 2007 · S/N FL-554 N454TMKardecas Corp · Houston, TXBuilt 1995 · S/N BB-1507 N4556MPerry Richard H · Crossville, TNBuilt 1978 · S/N E-1234 N4559MSky High Ventures LLC · Bartlett, TNS/N E-1235 N455BYasky Richard J · Seaford, VABuilt 1948 · S/N D-1472 N455PN455p LLC · Fulshear, TXBuilt 1999 · S/N E3276 N4560VCrane Russell S · Poplar Grove, ILBuilt 1948 · S/N D-1389 N4562MBbt Aviation LLC · Rapid City, SDBuilt 1978 · S/N E-1237 N4565SGl Aviation LLC · Mcmurray, PABuilt 1975 · S/N E-736 N4569SMiles Lawrence W Jr · Sacramento, CABuilt 1975 · S/N E-745 N456ADStafford Arthur · Oak Bluffs, MABuilt 1996 · S/N E-3026 N456BOr Meir Aviation · Youngstown, OHNon-citizen corporation, flight hours not reportedBuilt 1948 · S/N D-1473 N456BEBillionaire Inc · St Petersburg, FLFirst renewal noticeBuilt 1981 · S/N 335 N456DMHnw Aviation LLC · Melbourne, ARBuilt 1978 · S/N E-1378 N456ESTripp Aviation LLC · Pearland, TXBuilt 1983 · S/N BB-1107 N456PFCivic Aviation LLC · Miami, FLBuilt 1978 · S/N BB-413 N4572SQualley Patrick Dion · Brooklyn Park, MNBuilt 1975 · S/N E-744 N4578VMcpeck Adam S · Agar, SDFirst renewal noticeS/N D-1244 N4579VGcb Services LLC · Jacksonville, ORBuilt 1947 · S/N D-1221 N457ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 36355 N457BBRlm Investment Holdings LLC · Wilmington, NCBuilt 1994 · S/N TH-1712 N457BKForty Sixty Two B Inc · Lubbock, TXS/N TH-2028 N457DFUsda Forest Service Fepp · Mcclellan, CABuilt 1982 · S/N TH-1354 N457DTMathew Reggie T · Satellite Beach, FLBuilt 1997 · S/N E-3095 N457JAviation Leasing Group Inc · Wilmington, DEBuilt 1987 · S/N 258085 N457JCExceptional Aircrafts LLC · Mcallen, TXS/N 457 N457MSNesk Aviation LLC · Orlando, FLBuilt 1979 · S/N E-1523 N4584SAd Astra Aviation LLC · Shawnee, KSBuilt 1975 · S/N E-751 N4584VHarrison Megan · Des Moines, IABuilt 1947 · S/N D-1052 N4585MCorman Bruce D · Burlington, COBuilt 1978 · S/N E-1239 N4585SValiair Limited Company Trustee · Casper, WYBuilt 1975 · S/N E-752 N4587SSims Chad L · Marshall, TXBuilt 1975 · S/N E-753 N458BSwensson Sean C · Alpine, CABuilt 1948 · S/N D-1475 N458DACitation N458da LLC · Houston, TXS/N 560-0458 N458DGIron Street Aviation LLC · North Kansas City, MOBuilt 1973 · S/N TH-296 N458EABeach Boyz LLC · Saint Petersburg, FLS/N E3558 N458GLIowa Great Lakes Flyers Inc · Cheyenne, WYS/N TH-1376 N458JHVliegtuig Holdings LLC · Kalispell, MTBuilt 1996 · S/N E-3037 N458KAugust Aero LLC · Kalispell, MTBuilt 1974 · S/N TH-452 N458NCBartmann Management LLC · Weatherford, OKBuilt 1998 · S/N 560-0478 N458RMPjs Holdings LLC · Prior Lake, MNBuilt 1995 · S/N 650-7049 N458SSSos Ranch LLC · Humble, TXBuilt 1975 · S/N TH-569 N4590SConner Chad E · Paris, TNBuilt 1975 · S/N TH-676 N4597STopflight Air LLC · Dunkirk, INBuilt 1975 · S/N E-757

Back to AD 2006-16-18 R1