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.

N914ECPacific Rim Management LLC · Downey, CAS/N 258001N914SSMeregrass Inc · Dublin, TXBuilt 2001 · S/N 188N914TV1365 Swan Ridge Road LLC · New York, NYBuilt 1987 · S/N 14N915TPGlobe Resources Group LLC · Wichita, KSBuilt 1992 · S/N 122N917BCFlyaway Inc · Fort Worth, TXS/N 193N917JFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1999 · S/N 179N917MS917ms LLC · Longwood, FLBuilt 1994 · S/N 1241N917WMetro Helicopter LLC · Los Angeles, CABuilt 1991 · S/N 1158N918MVGuardian Aviation Services LLC · Short Hills, NJBuilt 1996 · S/N 156N918SCCharlie November One LLC · Sheridan, WYBuilt 1988 · S/N 1075N918XZAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1990 · S/N 258177N91JSReserve Aircrafts LLC · New York, NYBuilt 2002 · S/N 1485N91MSLabbe LLC · Huntington Valley, PABuilt 1987 · S/N 10N921TBBluemaxx Air LLC · Friendswood, TXS/N 85N924MBEvolution Development Partners LLC · Beverly Hills, CABuilt 1987 · S/N 1023N925DCAvion LLC · Birmingham, ALBuilt 1995 · S/N 1279N926TTSn 1372 LLC · Wilmington, DEBuilt 1999 · S/N 1372N927BRFur Management & Consulting LLC · Junction, TXBuilt 2002 · S/N 196N927JASn5028 LLC · Hollywood, FLBuilt 2000 · S/N 1426N92BSS&E Aviation LLC · Birmingham, MIBuilt 2003 · S/N 1502N935HPrestige Jets Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1992 · S/N NA0475N935RWelcome Grove LLC · West Sacramento, CABuilt 2000 · S/N 1405N936AM936am LLC · Mount Pleasant, SCBuilt 2002 · S/N 1488N939PGUrnxtjet LLC · Deland, FLBuilt 1993 · S/N 1212N945XCStratton Ventures LLC · Dover, DES/N 1019N947DTTkr Aviation LLC · Ballwin, MOBuilt 1992 · S/N 117N950SFTsl 2 LLC · Jackson, WYBuilt 1988 · S/N 50N951RMSiilats Keith · New York, NYS/N 3042N955DPN955dp LLC · Wilmington, DEBuilt 1988 · S/N NA0412N955MBHms Air LLC · Van Nuys, CABuilt 1987 · S/N 1022N956JMJam Aviation LLC · Laredo, TXBuilt 1993 · S/N 1223N958BXGulfstream 1227 LLC · Lewes, DEBuilt 1993 · S/N 1227N960CLDigital Interstate Management Inc · Keller, TXBuilt 1991 · S/N 094N960JSJordgrant1521 LLC · Santa Monica, CABuilt 2004 · S/N 1521N960LSNewport Executive Transportation Inc · Las Vegas, NVBuilt 1990 · S/N 1135N970JDFalcon Fawzi II LLC · Fort Lauderdale, FLBuilt 1992 · S/N 119N972MSGlf4 1285 LLC · Raleigh, NCBuilt 1996 · S/N 1285N976SCAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1989 · S/N NA0435N978CCSurfnturf Rec Holdings LLC · Camden, DES/N 1335N984JWNinety Eight Aviation LLC · Fort Myers, FLBuilt 1989 · S/N 1091N988AKExecutive Aircraft Sales LLC · Charlotte, NCBuilt 1987 · S/N 22N988TNext Century Aviation Oregon LLC · Sausalito, CABuilt 1988 · S/N 65N98LT98lt LLC · Austin, TXBuilt 1995 · S/N 1278N990LTLife Time Fitness Inc · Chanhassen, MNBuilt 1988 · S/N 60N990WRBam Aviation LLC · Jupiter, FLS/N 126N995GGAerovision Aircraft Holdings Inc · Dover, DEBuilt 1988 · S/N 1074N998GPAir Mccormack2 LLC · Chicago, ILBuilt 1988 · S/N 1061N999AASuperior Transportation Associates Inc · Costa Mesa, CABuilt 1996 · S/N 1286N999AHJet Black Aviation Group LLC · San Angelo, TXBuilt 1992 · S/N 1195N999HCHome Cloud Aviation LLC · West Palm Beach, FLBuilt 1999 · S/N 1394
Back to AD 89-02-10 R1