OpenAirDocs.org
AD 89-18-02 R1

Registered aircraft · 564

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-18-02-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-18-02-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.

N7983Ag Air Services LLC · Sunnyside, WABuilt 1971 · S/N 847N8005CAg Air Flying Service Inc · Toppenish, WABuilt 1996 · S/N 836BN80083Macys Flying Service Inc · Tulelake, CABuilt 1998 · S/N 837BN8014ZBank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 841BN8046KLewis Flying And Maintenance Svc Inc · Morse, LABuilt 1979 · S/N 546BN8057KMid Continent Aircraft Corp · Hayti, MOS/N 4DN8063KCe-Air Inc · Argyle, IABuilt 1979 · S/N 550 BN8066KHershey Flying Service Inc · David City, NEBuilt 1979 · S/N 552BN8080KHershey Flying Service Inc · David City, NEBuilt 1979 · S/N 554 BN8081KPrice William B · Lamar, SCS/N 555 BN8098KAerial Timber Applicators Inc · Cooperstown, NDS/N 563BN8102KWa-Co Enterprises Inc · Enid, MSS/N 564BN8104KSmith David C · Malott, WAS/N 565BN8110KMeadow Creek Aerial Application Inc · Kelliher, MNS/N 570BN8114KHershey Flying Service Inc · David City, NES/N 569BN8116KTatro Christopher A · Madras, ORBuilt 1979 · S/N 572BN8126KOndrak Air LLC · Shelton, NEBuilt 1979 · S/N 574BN8128KGasper Air Spray Inc · Crookston, MNBuilt 1979 · S/N 575BN8133KButte County Mosquito And Vector Control District · Oroville, CAS/N 579BN8137KSky Tractor LLC · Hillsboro, NDS/N 580BN8138KEckles Aircraft LLC · Holdenville, OKS/N 581BN8148KHeimgartner Aviation LLC · Juliaetta, IDBuilt 1979 · S/N 586BN814YBHershey Flying Service Inc · David City, NES/N 818BN8150KKuther Air Service · Nezperce, IDBuilt 1979 · S/N 587BN8151KTurbines Inc · Terre Haute, INBuilt 1979 · S/N 590BN8157KStorm Flying Service LLC · David City, NEBuilt 1979 · S/N 591BN8172KBuntings Dusting Inc · Berlin, MDBuilt 1979 · S/N 600BN8178GCw Equipment Rentals Inc · Biggs, CABuilt 1988 · S/N 796BN8197KGulfstream Aerospace Corp · Savannah, GABuilt 1979 · S/N 610BN8214SCw Equipment Rentals Inc · Biggs, CABuilt 1986 · S/N 787BN8222KKramr David J · Lissie, TXBuilt 1979 · S/N 617-BN8231KAerial Control Inc · Brentwood, CABuilt 1979 · S/N 623-BN8247KSlikker Flying Service Inc · Buttonwillow, CABuilt 1979 · S/N 632-BN8260KBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 639BN8263KGulfstream Aerospace Corp · Savannah, GABuilt 1979 · S/N 641BN8276KThompson Aero Inc · Amana, IAS/N 644-BN8289KValley Air Service Limited · Colusa, CABuilt 1980 · S/N 648BN8296KSmith David C · Brewster, WAS/N 650BN8301KLejeune Gene R · Crowley, LAS/N 653BN83110Jones Aviation Inc · Biggs, CAS/N 11DN8315KAg Aviation Inc · Welsh, LAS/N 13DN8317KPorter Flying Service LLC · Missoula, MTS/N 14DN8326KCw Equipment Rentals Inc · Biggs, CABuilt 1980 · S/N 656BN8341KAlaska Air Service LLC · Brookings, ORS/N 35CN8347KPorter Flying Service LLC · Missoula, MTBuilt 1980 · S/N 22DN8351KFranklin Dirk W · Beaumont, TXBuilt 1980 · S/N 658BN8363KDonovan Duane E · Bloomington, NES/N 663BN8375KR & S Aviation LLC · Corning, ARS/N 668BN8378Shav Leasing · Ivins, UTBuilt 1971 · S/N 870N8379Rafter V Ranch Inc · Rio Oso, CABuilt 1971 · S/N 872
Back to AD 89-18-02 R1