OpenAirDocs.org
AD 89-07-07 R1

Registered aircraft · 673

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-07-07-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-07-07-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.

N400JJEagle Valley Investments LLC · Scottsdale, AZBuilt 1981 · S/N T-400N400LRKelly Aero LLC · Montgomery, ALBuilt 1984 · S/N 42-5527003N400PSBarnett Sheila · Catoosa, OKBuilt 1979 · S/N 411 S.A.N400RTWagner Air LLC · Kendalia, TXBuilt 1979 · S/N T-311N400VBKelleher Corporation · San Rafael, CABuilt 1985 · S/N 42-5527002N401RRFlying Ace LLC · Manchester, MIBuilt 2022 · S/N LIV-486N40261Jones Aviation Inc · Biggs, CABuilt 1999 · S/N G10-158N404VAInternational Bank Of Commerce · Laredo, TXBuilt 1987 · S/N 8120N405CPConocophillips Alaska Inc · Anchorage, AKBuilt 1990 · S/N 405N405SAWpp Nautical LLC · Helena, MTBuilt 1980 · S/N T329N405VAInternational Bank Of Commerce · Laredo, TXS/N 8144N406VAInternational Bank Of Commerce · Laredo, TXS/N 8149N4089QBruces Flying Service Inc · Arlington, GABuilt 1999 · S/N G10-163N4090MCorsair Turbines LLC · Georgetown, TXBuilt 1979 · S/N TC290N4090WMauck Flying Service LLC · Hoxie, KSBuilt 2000 · S/N G1-115N409VAZeroavia Inc · Hollister, CAS/N 8097N40AMAisling Developments LLC DBA · Calhoun, GABuilt 1980 · S/N 427 S.A.N40JJIntercontinental Jet Service Corp · Tulsa, OKBuilt 1978 · S/N 383SAN40KCAir 1st Aviation Companies Inc · Glendale, AZBuilt 1974 · S/N 322N4152XAero Spray Inc · Kingfisher, OKBuilt 1974 · S/N 1928RN419SCZeplane LLC · Miami, FLBuilt 1980 · S/N 441-0149N41LHSkyventure Arizona LLC · Eloy, AZBuilt 1981 · S/N SH 1977N4206PHeritage Ag LLC · Lakeview, MIBuilt 2001 · S/N G10-166N4208SOmega Air Service LLC · Fredericksburg, OHBuilt 2001 · S/N G10-167N420LWCrazy Horse LLC · Princeton, WVS/N 11455N4217XEarls Spray Service Inc · Breckenridge, MIBuilt 2001 · S/N G10-168N421MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-634N4223XAir Enterprises LLC · Dover, DEBuilt 1974 · S/N 1984RN422CABering Air Inc · Nome, AKBuilt 1982 · S/N 238N4239XMountain Air Spray Co · Craig, COBuilt 1974 · S/N 2012RN423DB2945l LLC · Terrell, TXS/N 1543 S.A.N423KAKmr Aviation Services Inc · Lynchburg, VABuilt 1993 · S/N 41023N424CARyan Air Inc · Anchorage, AKBuilt 1981 · S/N 242N424MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-639N425DFUsda Forest Service Fepp · Mcclellan, CABuilt 1999 · S/N 152825N425DTSun Fast Inc · Mansfield, TXBuilt 1978 · S/N 11519N425MACbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-640N426CASpitaker Leasing LLC · Colorado Springs, COBuilt 1981 · S/N 168N426DFUsda Forest Service Fepp · Mcclellan, CABuilt 1999 · S/N 152824N426MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-645N428MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-646N42AFWild Hare Enterprises LLC · Valparaiso, INBuilt 1980 · S/N 787 S.A.N42AXTheia Aviation LLC · Philadelphia, PABuilt 1996 · S/N 41084N430MAGas/Wilson Inc · Traverse City, MIS/N AC-710BN430RRAce In The Sky LLC · San Antonio, TXBuilt 1974 · S/N AT030N431MTDucharme Paul Quinn · Lafayette, LAS/N LIV-517N434CAHorizon Aire LLC · Colorado Springs, COBuilt 1981 · S/N 286N439DFUsda Forest Service Fepp · Mcclellan, CABuilt 2002 · S/N 149854N439RARyan Air Inc · Anchorage, AKBuilt 1982 · S/N 287N43GTDon Avion LLC · Cedar Park, TXBuilt 1978 · S/N 441-0043
Back to AD 89-07-07 R1