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.

N6677QStraightline Ag LLC · Moberly, MOBuilt 1977 · S/N 198BN6679QSherman Janet · Dillon, SCBuilt 1977 · S/N 200BN667FAHershey Flying Service Inc · David City, NEBuilt 1978 · S/N 431BN6680KJohnson Fertilizer Co Inc · Sayre, OKBuilt 1978 · S/N 415BN6680QHershey Flying Service · David City, NEBuilt 1977 · S/N 1699N6681KMoes Crop Dusting Service Inc · Marysville, CAS/N 20CN6682KDickenson Mike J · Chickasha, OKBuilt 1978 · S/N 416BN6683KHoppe Airspray LLC · Conrad, IABuilt 1978 · S/N 417 BN6688QThompson Aero Inc · Amana, IABuilt 1977 · S/N 206BN6689QMorten John E · Larimore, NDS/N 205BN6691QAg Aviation Service Inc · Elkhorn, WIBuilt 1977 · S/N 216BN6692KHouston Ag Flying Service Inc · Owensboro, KYS/N 423BN6693KJones Aviation · Biggs, CABuilt 1978 · S/N 22 CN6694KJones James Murrell Jr · Monroe, LABuilt 1978 · S/N 424BN6695QRegistration Pending · Wills Point, TXRegistration pendingBuilt 1977 · S/N 209BN6696KValley Air Service Ltd · Colusa, CABuilt 1978 · S/N 426BN6697QHayton James B · Sedro Woolley, WABuilt 1977 · S/N 207BN6699QS & S Aviation LLC · Morse, LABuilt 1977 · S/N 214BN66EAEvans Aviation Inc · Imlay City, MIBuilt 1979 · S/N 38CN6700KMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1978 · S/N 429 BN6704QHaley Flying Service Inc · Tracy, CABuilt 1977 · S/N 220BN6710QWinemiller Steve DBA · Swifton, ARBuilt 1977 · S/N 226BN6714KThompson Aero Inc · Amana, IABuilt 1978 · S/N 433BN6715QMid Continent Aircraft Corp · Hayti, MOS/N 1709N6716QSale Reported · Pelkie, MISale reported, pending cancellationBuilt 1977 · S/N 1710N6717QAlaska Air Service LLC · Brookings, ORS/N 1711N6718KScott Flying Service Inc · Bono, ARBuilt 1978 · S/N 436BN6719QAltendorf Richard C · Northwood, NDBuilt 1977 · S/N 230BN6720KScott Flying Service Inc · Bono, ARBuilt 1978 · S/N 437BN6720QMike Jones Flying Service Inc · Monroe, LABuilt 1977 · S/N 238BN6722KThayer Agricultural Aviation Inc · Grimes, CABuilt 1978 · S/N 29CN6723QJk Sky Farm LLC · Adairville, KYBuilt 1977 · S/N 234BN6725KSlikker Flying Service Inc · Buttonwillow, CABuilt 1978 · S/N 438BN6726QAvery Walter · Maxwell, CABuilt 1977 · S/N 237BN6728QAg Flyers Inc · Torrington, WYBuilt 1977 · S/N 241BN6730KBasin Aviation Inc · Rio Oso, CABuilt 1978 · S/N 441 BN6732KPorter Flyling Service Inc DBA · Durham, CABuilt 1978 · S/N 27CN6733QDickenson Mj · Chickasha, OKS/N 247BN6735KMid Continent Aircraft Corp · Hayti, MOBuilt 1978 · S/N 30CN6738QRuchert William S Personal Representative · Pomeroy, WAS/N 252BN6741QPalmer Ag Air · Novelty, MOS/N 1714N6745KDc Applicator · Brentwood, CAS/N 446BN6746QMorgans Flying Service LLC · Morse, LABuilt 1977 · S/N 258BN6752KThayer Agricultural Aviation Inc · Grimes, CABuilt 1978 · S/N 452BN6754QKingrey Bill · Richmond, TXBuilt 1977 · S/N 265BN6760KWells Ag Aviation LLC · Saint Paul, NEBuilt 1978 · S/N 434BN6761QHershey Flying Service Inc · David City, NEBuilt 1974 · S/N 1352N6762QWhalen Mark P · Millington, MDBuilt 1977 · S/N 1719N6771QAir Services Inc · Minneapolis, KSS/N 280BN6772QVincent Flying Service Inc · Kaplan, LAS/N 281B
Back to AD 89-18-02 R1