OpenAirDocs.org
AD 2001-08-13

Registered aircraft · 606

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
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:2001-08-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-13')
  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.

N192JERegistered aircraftBuilt 2002 · S/N 1491N1948ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 600N194MFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 510N1956MRegistered aircraftBuilt 2002 · S/N 675N195PASandy Wings LLC · Wilmington, DEBuilt 1983 · S/N 399N1967JEagle Mountain International Church Inc · Newark, TXBuilt 2000 · S/N 602N196PASandy Wings LLC · Wilmington, DES/N 321N1979LCabana Air LLC · Frederick, MDS/N 1480N197BDAfc Management LLC · Englewood, NJBuilt 1996 · S/N 1284N198GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 1098N198PABartowjets LLC · Wilmington, DEBuilt 1986 · S/N 482N1AMMeruelo Group LLC · Downey, CABuilt 2000 · S/N 623N1BBBollinger Enterprises LLC · New Orleans, LABuilt 2001 · S/N 660N1BGGlobal Empire Trust LLC · Dover, DEBuilt 2001 · S/N 1436N1DWac I LLC · Fort Lauderdale, FLBuilt 1992 · S/N 1209N1DCBlue Star Management Services Corp · Frisco, TXBuilt 2001 · S/N 651N1HGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 1534N1JMWhiskey Uniform LLC · Wichita Falls, TXS/N 682N1TDThreshold Ventures Inc · Scottsdale, AZBuilt 1990 · S/N 1133N1TMMarsico Aviation LLC · Denver, COBuilt 2002 · S/N 1490N2000Global Avionics LLC · Downey, CAS/N 56N200LCSn 1067 LLC · Wilmington, DEBuilt 1988 · S/N 1067N202PXZ & L Consulting LLC · Midland, TXS/N 17N2107ZAir Prestigio LLC · Aliso Viejo, CAS/N 1211N211DHHagadone Aviation LLC · Coeur D Alene, IDBuilt 2000 · S/N 1432N213EFMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1996 · S/N 1283N215BBBl Charter LLC · Pittsfield, MABuilt 2000 · S/N 610N218EESolomon Mark Trustee · Wilmington, DEBuilt 1986 · S/N 489N218KDMojave Jet LLC · Wilmington, DEBuilt 1991 · S/N 1164N218MDNe-2 LLC · Houston, TXBuilt 2003 · S/N 1515N220TDRegistration Pending · Rantoul, KSRegistration pendingBuilt 1988 · S/N 1070N221EAGlobal Acquisition Holdings LLC · Oklahoma City, OKBuilt 2002 · S/N 1476N221MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4038N222GYSpec Air LLC · Miami, FLBuilt 1990 · S/N 1142N222LXTrans Exec Air Service Inc · Van Nuys, CABuilt 2001 · S/N 633N222NPAircraft Fidelity Corp Trustee · Dover, DES/N 245N225DCAvion LLC · Birmingham, ALBuilt 1994 · S/N 1253N225ELThesun LLC · Miami, FLBuilt 1999 · S/N 587N226MPExecutive Jet Group LLC · Opa Locka, FLBuilt 1996 · S/N 1300N226RS226rs LLC · Cypress, TXBuilt 2002 · S/N 1479N226SLSpencer Talia Aviation LLC · Los Angeles, CABuilt 2001 · S/N 628N227LAK&A Advisors LLC · Wilmington, DEBuilt 1976 · S/N 193N228RECape Clear LLC · Westborough, MABuilt 2001 · S/N 1438N229KMMike Post Productions Inc · Burbank, CABuilt 1996 · S/N 504N232FN232k LLC · Midland, TXBuilt 1993 · S/N 1232N234LRDanish Jet Inc Trustee · Cheyenne, WYBuilt 1980 · S/N 300N236CACypress Cove Air LLC · Phoenix, AZBuilt 1992 · S/N 1202N239GACentury Aviation International Inc · Wilmington, DEBuilt 1997 · S/N 517N247LMLive Mas Enterprises LLC · Greenwood Village, COBuilt 1994 · S/N 1258N24YSRegistered aircraftBuilt 1968 · S/N 16
Back to AD 2001-08-13