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.

N6509KMeadow Creek Aerial Application Inc · Kelliher, MNBuilt 1977 · S/N 345BN651YPhillips Carlton T · Walnut Ridge, ARBuilt 1964 · S/N 260N6524KJones Aviation Inc · Biggs, CABuilt 1977 · S/N 352BN6527KHock Gregory G · Culbertson, NES/N 353BN6528KPorter Wade · Durham, CABuilt 1977 · S/N 354BN6535Vanderpool Gary W · Alamo, TXBuilt 1969 · S/N 683N6535KJones Aviation Inc · Biggs, CABuilt 1977 · S/N 3CN6538Holtz Britton N · Clarksburg, CABuilt 1969 · S/N 670N6542Hanke Kenneth O · Clio, SCBuilt 1969 · S/N 682N6547Page Elbert DBA · Clio, SCBuilt 1969 · S/N 695N6548Petersen Jacob · Tyler, MNBuilt 1969 · S/N 692N6553Tall Towers Aviation Inc · Page, NDBuilt 1970 · S/N 696N6555KJones Flying Service · Biggs, CABuilt 1978 · S/N 4CN6565Ag Air Inc · Raceland, LABuilt 1970 · S/N 722N6565KHouston Ag Flying Sev Inc · Owensboro, KYBuilt 1978 · S/N 371BN6569Sale Reported · Friedenburg, PASale reportedBuilt 1970 · S/N 709N6569KJones Aviation · Biggs, CABuilt 1978 · S/N 5CN6571KAj Aviation LLC · Gwinner, NDBuilt 1978 · S/N 376BN6583Schwend Brian DBA · Forsyth, MTBuilt 1970 · S/N 720N6594Smith David C · Malott, WABuilt 1970 · S/N 733N6596KJones Aviation Inc · Biggs, CABuilt 1978 · S/N 6CN6598KSky Tractor LLC · Hillsboro, NDBuilt 1978 · S/N 381BN659UChandler Will W · Texarkana, TXBuilt 1966 · S/N 395N6608KBenoit Aerial Spraying Inc · Bourbonnais, ILBuilt 1978 · S/N 386BN6608QHershey Flying Service Inc · David City, NEBuilt 1976 · S/N 135BN6609QMid Continent Aircraft Corp · Hayti, MOBuilt 1976 · S/N 136BN660UMid Continent Aircraft Corp · Hayti, MOBuilt 1966 · S/N 396N6611KMj Aviation Inc · Tuckerman, ARS/N 394BN6612QAlaska Air Service LLC · Brookings, ORS/N 163BN6613KDc Applicator · Brentwood, CABuilt 1978 · S/N 390BN661YTriple F Flying Inc · Benton, PAS/N 204N6620KLewis Flying & Maintenance Serv Inc · Morse, LABuilt 1978 · S/N 397BN6620QDowntown Airport Inc · Vineland, NJBuilt 1976 · S/N 1693N6622QGasper Air Spray Inc · Crookston, MNS/N 1689N6624QThompson Aero Inc · Amana, IABuilt 1976 · S/N 150BN6627Richter Aviation Inc · Maxwell, CABuilt 1970 · S/N 757N6628QSale Reported · Saint John, WASale reportedBuilt 1976 · S/N 154BN6632QStraightline Ag LLC · Moberly, MOS/N 159BN6645QBuntings Dusting Inc · Berlin, MDS/N 172BN6648QCw Equipment Rentals Inc · Biggs, CAS/N 175BN664UMurphy Airport Inc · Amsterdam, NYBuilt 1966 · S/N 400N6650QLewis Flying Maintenance Svc Inc · Morse, LABuilt 1977 · S/N 177BN6652QO & K Aviation Inc · Newport, ARBuilt 1977 · S/N 179BN6654KAir Enterprises LLC · Dover, DES/N 409BN666FARidgway Rick J · Carlisle, INBuilt 1977 · S/N 203BN6670KWells Garry L · Scotia, NEBuilt 1978 · S/N 413BN6671KRichter Aviation Inc · Maxwell, CABuilt 1978 · S/N 15CN6674KRichter Aviation Inc · Maxwell, CABuilt 1978 · S/N 16CN6676KAvag Inc · Richvale, CAS/N 17 CN6676QZahm'S Aerial Enterprises LLC · Marne, MIS/N 197B
Back to AD 89-18-02 R1