Registered aircraft · 11,797

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.

N929FDFaust Distributing Co Inc · Houston, TXBuilt 2000 · S/N LJ-1585 N929FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0029 N929JDMake Aviation Great Again LLC · Kalispell, MTBuilt 1987 · S/N E-2387 N929JTDulcich Nick Prosper · Bakersfield, CABuilt 1993 · S/N 525-0011 N929MMOtm Equipment LLC · Westlake, TXBuilt 2009 · S/N 525-0692 N929NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33322 N929NYFox Hotel Holdings LLC · Ronkonkoma, NYFirst renewal noticeBuilt 2016 · S/N 208B5331 N929SGSierra Gulf Equipment LLC · Midland, TXBuilt 2014 · S/N FL-909 N929TGPa1 208b-0371 LLC · Fort Lauderdale, FLBuilt 1993 · S/N 208B0371 N92CJSkyview LLC · Wilmington, DEBuilt 1982 · S/N 092 N92CLAircraft Structures International Corp · Enid, OKBuilt 1989 · S/N 208B0185 N92CVRandall Grier Ministries · Owasso, OKBuilt 1984 · S/N 421C1065 N92DFN92df Slo LLC · Arroyo Grande, CAS/N 421C0889 N92DVMile Hi Skydivers Inc · Longmont, COS/N LW-292 N92FEWarren Transportation LLC · Dallas, TXBuilt 1969 · S/N 242 N92FFAircraft 2 Go ! Inc · Wilmington, DES/N TH-1167 N92HJWoolley Air LLC · Kilgore, TXBuilt 1991 · S/N TH-1621 N92JJPa1 208b-1074 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1074 N92JTHigh Shadow LLC · Roach, MOBuilt 1980 · S/N LA-73 N92JWKennedy Donald R Jr · New Philadelphia, OHBuilt 1974 · S/N E600 N92RKSnk Real Property Holdings LLC · Meta, MOBuilt 1996 · S/N LJ-1458 N92SBLone Star Air LLC · Castle Rock, COBuilt 2022 · S/N 525-1106 N92SSUS Trinity Equipment LLC · Argyle, TXBuilt 1996 · S/N 560-0388 N92TTKent Oscar Kevin · Lucas, IABuilt 1972 · S/N TH-226 N92TXMjh Aviation LLC · Leander, TXBuilt 2016 · S/N FL-1064 N92UPTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1997 · S/N 258309 N92WCAviation Group LLC · Wilmington, DEBuilt 1989 · S/N BB-1330 N92WEInce Aviation LLC · Dover, DEBuilt 1984 · S/N LJ1090 N92WGDndd Capital Holdings LLC · Plano, TXBuilt 2015 · S/N 525-0871 N9302QSmith Winston C · Colleyville, TXBuilt 1971 · S/N E-294 N9304FSkydive Baltimore LLC · Lincoln, DEBuilt 1985 · S/N 20800008 N930AAN930aa LLC · Memphis, TNBuilt 1977 · S/N E-1139 N930ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 29529 N930BDMomentum Air LLC · Brighton, MIBuilt 1973 · S/N TH-307 N930DSAc Aircraft Holdings LLC · Dallas, TXBuilt 1999 · S/N FL-252 N930DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63539 N930FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0030 N930MCCorporate Flights LLC · Mishawaka, INS/N LJ-1720 N930MQGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1463 N930NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33487 N930PCTrust Aviation LLC · Columbia, SCS/N E-3442 N9310FPa1 208b-0490 LLC · Fort Lauderdale, FLBuilt 1995 · S/N 208B0490 N9310QMc Types II LLC · Jacksonville, FLBuilt 1971 · S/N TH-180 N9314FMission Aviation Fellowship · Nampa, IDBuilt 1985 · S/N 20800010 N931ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30079 N931CAWild Aviation LLC · Rockford, ILBuilt 2002 · S/N 258586 N931ELSworks Aviation LLC · Chicago, ILFirst renewal noticeBuilt 1996 · S/N 258316 N931FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0031 N931GGPc Aviation LLC · Albany, GABuilt 1999 · S/N LJ-1572 N931NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33230

Back to AD 2006-16-18 R1