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.

N3628TMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1984 · S/N 737BN3628ZMcclung Aerial Spraying · Big Springs, NEBuilt 1984 · S/N 738BN3629DWallace Aviation Inc · Wallace, NEBuilt 1984 · S/N 743BN3629JVincent Flying Service Inc · Kaplan, LABuilt 1984 · S/N 747BN3629KScott Flying Service Inc · Bono, ARBuilt 1984 · S/N 748BN3629NWatson Air Farm LLC · Donaldsonville, LAS/N 749BN36303Raider Aviation LLC · Southampton, NJBuilt 1984 · S/N 761BN3630BWallace Aviation Inc · Wallace, NEBuilt 1984 · S/N 755BN3630UCajun Cats LLC · Kaplan, LAS/N 760BN3632TMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1985 · S/N 772BN36333Sky Tractor LLC · Hillsboro, NDBuilt 1986 · S/N 785BN3633CCw Equipment Rentals Inc · Biggs, CAS/N 776BN3633SKingrey William Sampson III · Richmond, TXBuilt 1986 · S/N 778BN3633TAerial Control Inc · Brentwood, CABuilt 1986 · S/N 779BN407YHendrickson Gary A · Chico, CABuilt 1963 · S/N 217N410XBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 631N41844Todd Greggory S · Ankeny, IAS/N 385BN4241Ham Orlando DBA · Opdyke, ILBuilt 1972 · S/N 1011N4244Kingsley Kiman J · Miller, MOBuilt 1973 · S/N 1034N425LSRed Willow Rescue Inc · Cooperstown, NDS/N 598BN4369Lewis Flying & Maint Svc Inc · Morse, LABuilt 1973 · S/N 1045N43875Cascade Airways LLC · Corvallis, ORS/N 766BN440ETHoppe Air LLC · Beaman, IABuilt 1977 · S/N 222BN4450Registered aircraftS/N 1048N447TAThompson Aero Inc · Amana, IABuilt 1977 · S/N 187BN4508Page Marion E · Clio, SCBuilt 1973 · S/N 1050N4536Mid Continent Aircraft Corp · Hayti, MOBuilt 1973 · S/N 1053N4591Kramr David J · Lissie, TXBuilt 1973 · S/N 1066N460YRuiz Segundo Garcia · Ponce, PRBuilt 1962 · S/N 151N4623Breum Sean M · Stanwood, WABuilt 1973 · S/N 1087N4630Jones Aviation Inc · Biggs, CABuilt 1973 · S/N 1176N464YTonner Daniel J · Conrad, IABuilt 1962 · S/N 110N4698Hershey Flying Service Inc · David City, NES/N 1081N4728Porter Flying Service Inc · Chico, CAS/N 1089N4757Double D Flying Service Inc · Leesburg, GABuilt 1973 · S/N 1091N4778TContinental Title Trust LLC · Wichita, KSBuilt 1963 · S/N 220N478YFerr Spray Aerial Application LLC · Marengo, ILBuilt 1962 · S/N 123N479YGustin Aviation Inc · Lewiston, IDBuilt 1962 · S/N 124N481YKyle E Rich Inc · Sumner, IABuilt 1962 · S/N 126N48348Sug-Air LLC · Lubbock, TXS/N 9BN48372Farrell Drew M · Maryville, MOBuilt 1976 · S/N 12BN48374Ag Cat Applicators LLC · Avoca, TXBuilt 1976 · S/N 1619N48377Ag Spraying LLC · Bonner Springs, KSBuilt 1975 · S/N 1541N48383Jones James M Jr · Monroe, LABuilt 1976 · S/N 1623N48402Jones Ken · Grenada, MSBuilt 1976 · S/N 1630N48403Nielsen Richard D · Crystal Beach, TXBuilt 1976 · S/N 1631N48405Northwood Aero Service · Northwood, NDS/N 1632N48413Bayou Dusters LLC · Moreauville, LABuilt 1976 · S/N 16BN48423Thompson Frank L · Weiser, IDBuilt 1976 · S/N 18BN48436Wakefield John DBA · Cooperstown, NDBuilt 1976 · S/N 78B
Back to AD 89-18-02 R1