OpenAirDocs.org
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.

N44GVN44gv LLC · Pacific Palisades, CABuilt 1997 · S/N 1305N450EJPremier Air Charter Inc · Carlsbad, CABuilt 1995 · S/N 1273N450FVYellowdome LLC · Emigrant, MTBuilt 1992 · S/N 112N450LRRicotta Lance · Yuma, AZBuilt 1988 · S/N 1013N450MBAircraft Fidelity Corporation Trustee · Dover, DEBuilt 1996 · S/N 1295N450PZN800pz LLC · Las Vegas, NVBuilt 1996 · S/N 1299N451GAStratton Ventures LLC · Wilmington, DEBuilt 1993 · S/N 1221N451KRAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2001 · S/N 1451N455WGAlliance Aviation Group LLC · Wilmington, DEBuilt 1992 · S/N 1205N455ZSparta Aviation Group LLC · Saint Petersburg, FLBuilt 1994 · S/N 1235N457DSBest Aircraft Deals LLC · Salt Lake City, UTS/N 1077N457JAviation Leasing Group Inc · Wilmington, DEBuilt 1987 · S/N 258085N45GDPacific Rim Management LLC · Middletown, DEBuilt 1989 · S/N 258142N45WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3004N460AKTangier Services LLC · Mill Valley, CABuilt 2000 · S/N 1413N469RJDodson International Parts Inc · Rantoul, KSBuilt 1986 · S/N 258067N46HBSunshining Aviation LLC · Wilmington, DEBuilt 1988 · S/N 42N472MMSmb G-IV II LLC · Longwood, FLS/N 1072N473CWAlfa Fox X LLC · Sebring, FLBuilt 1992 · S/N 1194N474XWashington Penn Plastic Co Inc · Washington, PABuilt 2001 · S/N 1445N475LCIntrajet Corp · Kalispell, MTBuilt 2002 · S/N 1472N477GG477 Aviation LLC · Beverly Hills, CABuilt 1987 · S/N 1032N478GSIntrajet Corp · Kalispell, MTBuilt 2002 · S/N 1478N47HWCelebration Tv America Inc · Houston, TXS/N 258023N480LALuxury Aero Collection LLC · Scottsdale, AZBuilt 1983 · S/N 3003N480VRMmap LLC · Denver, COBuilt 1999 · S/N 1380N481SCRjs Aviation LLC · Fort Myers, FLBuilt 1997 · S/N 1313N484FMV1vr LLC · Wilmington, DES/N 81N485GMGlobal Destinations LLC · Beaumont, TXBuilt 1997 · S/N 1311N48GLGenesis Adventures LLC · Brea, CABuilt 1988 · S/N 1052N48KZN48kz LLC · Long Beach, CABuilt 2001 · S/N 191N495JSP&P Air LLC · Salem, NHBuilt 1998 · S/N 1336N495WGAir Kuz LLC · Jamison, PABuilt 1993 · S/N 1214N49RFUnited States Department Of Commerce · Lakeland, FLBuilt 1994 · S/N 1246N4BAMonte Carlo Associates LLC · Santa Ana, CABuilt 2003 · S/N 200N4DPGreen Chair Productions Inc · Los Angeles, CABuilt 1989 · S/N 1097N501RBLone Star Land & Cattle Co · Houston, TXBuilt 1990 · S/N 1138N504PASmee Homes Inc · Porterville, CABuilt 1988 · S/N 43N504STSdt Air Delaware LLC · Wilmington, DEBuilt 1996 · S/N 162N508MMMarklyn Jet Parts LLC · Dallas, TXS/N 66N509CQBwp Aviation LLC · Nashville, TNBuilt 1993 · S/N 1233N50LKTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTBuilt 1994 · S/N 1252N510MGSuperior Transportation Associates Inc · Costa Mesa, CABuilt 1998 · S/N 1349N510SPKitty Hawk LLC · Fort Worth, TXBuilt 1993 · S/N 1183N511KA1111 Giv LLC · Downey, CABuilt 1989 · S/N 1111N512CCCd 357 LLC · Austin, TXBuilt 2001 · S/N 1446N513LSSpec Air LLC · Saint Petersburg, FLBuilt 1991 · S/N 1178N515LFAdelante Aviation LLC · Leawood, KSBuilt 1986 · S/N 3052N515RAA & E Hawker Lp · Santa Ana, CABuilt 2000 · S/N 1434N516JAKings Aviation Corp · Garden City, NYBuilt 1991 · S/N 089
Back to AD 89-02-10 R1