AD 89-02-10 R1

Registered aircraft · 603

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:89-02-10-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:89-02-10-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.

N880CFBoss 8 LLC · Fort Worth, TXBuilt 1988 · S/N 1082N880ECDodson International Parts Inc · Rantoul, KSS/N 56N883LDV-Jet Aircraft Holding Co Trustee · Dover, DEBuilt 2001 · S/N 1441N884ABJetsteam Aviation Inc · Cheyenne, WYS/N 258097N884BBHf III LLC · Saint Paul, MNBuilt 1987 · S/N 17N884CFN360kv LLC · Modesto, CABuilt 2001 · S/N 1435N887MRFouga LLC · Dover, DEBuilt 1994 · S/N 1251N8881JGdc Aviation LLC · Jacksonville, FLBuilt 1992 · S/N 258219N888CSZg Aviation LLC · New York, NYBuilt 2001 · S/N 1469N888ESSpinair LLC · Saratoga, CABuilt 1989 · S/N 1120N888FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 1041N888MFSn 1268 Inc · Wilmington, DEBuilt 1995 · S/N 1268N888YGGy Gulfstream LLC · Las Vegas, NVBuilt 2003 · S/N 1519N889BHPrima Air Group LLC · Pasadena, CABuilt 1989 · S/N 1121N889CGPrima Air LLC · Pasadena, CABuilt 1999 · S/N 1386N893TASta Aviation Management · New York City, NYBuilt 1983 · S/N 3016N898Rare Air Aviation Services LLC · Santa Rosa, CABuilt 2005 · S/N 4019N899ALGulfstream Givsp 1495 LLC · East Hampton, NYBuilt 2002 · S/N 1495N900BKRck Aviation LLC · Woodside, CABuilt 2000 · S/N 187N900DTega Air LLC · Bend, ORBuilt 1993 · S/N 131N900EEIrish Air II LLC · Cincinnati, OHS/N 80N900ERJdr 192 LLC · Woody Creek, COBuilt 2001 · S/N 192N900KUFalcon 900-91 LLC · Lewes, DEBuilt 1991 · S/N 91N900KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 53N900LCMid Central Leasing LLC · Waukegan, ILBuilt 2000 · S/N 186N900LPDoctair Inc · Mclean, VABuilt 1987 · S/N 20N900MKRacer X LLC · Chicago, ILBuilt 1988 · S/N 40N900MWGlobal Jet Partners LLC · Scottsdale, AZS/N 78N900SBBg Air LLC · Hobbs, NMBuilt 1991 · S/N 107N900SFFalcon 900 LLC · Mount Laurel, NJBuilt 1987 · S/N 16N900TEFalcon 900 LLC · Ocala, FLBuilt 1986 · S/N 12N900TNRegistered aircraftBuilt 1996 · S/N 158N900VCFalcon-121 LLC · Salem, ORBuilt 1992 · S/N 121N900VPJdr 194 LLC · Woody Creek, COBuilt 2002 · S/N 194N900WRReaud Wayne A · Santa Fe, NMBuilt 2000 · S/N 1416N900YBBold Access LLC · Leawood, KSBuilt 1987 · S/N 18N900YYBbps Aviation LLC · Mckinney, TXBuilt 1991 · S/N 101N901KRAvatar Wings LLC · Dallas, TXBuilt 1994 · S/N 146N905FJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 1986 · S/N 5N905LPChateau Aviation LLC · Wilmington, DEBuilt 1997 · S/N 1321N908JTValiair Lc Trustee · Casper, WYBuilt 1990 · S/N 1145N90FJWorldwide Aircraft Services Inc DBA · Tampa, FLBuilt 1998 · S/N 75N90GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N 29N90RGRobtoria Aircraft Leasing LLC · Wilmington, DEBuilt 2000 · S/N 1410N90THJ & J Capital Ventures LLC · Wilmington, DEBuilt 1999 · S/N 180N910AFAfh Aviation LLC · Mineola, NYBuilt 1997 · S/N 1312N910NMTriangle Real Estate LLC · Saint Peters, MOS/N 95N910SCSunchasing LLC · Newark, DEBuilt 1994 · S/N 144N910TX900 Consulting LLC · Austin, TXBuilt 1998 · S/N 172N913SCAircraft Holding Solutions LLC · Newark, DES/N NA0418
Back to AD 89-02-10 R1