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.

N48442Mid Continent Aircraft Corp · Hayti, MOBuilt 1976 · S/N 1646N48445Mid Continent Aircraft Corp · Hayti, MOBuilt 1976 · S/N 21BN48449Lewis Flying & Maintenance Svc · Morse, LABuilt 1976 · S/N 23BN48452Jones Aviation Inc · Biggs, CABuilt 1976 · S/N 24BN48455Crawford Aviation Services LLC · Flagstaff, AZBuilt 1976 · S/N 28BN48468Tumbleweed Leasing LLC · Tacoma, WABuilt 1976 · S/N 1649N48473Palouse Ag Leasing LLC · Moscow, IDBuilt 1976 · S/N 1654N48474Albright Frank E · Elba, ALBuilt 1976 · S/N 32BN48484Jones Aviation Inc · Biggs, CAS/N 43BN48489Price William B · Lamar, SCBuilt 1976 · S/N 1651N48491Hartwig Lonnie · Edgeley, NDBuilt 1976 · S/N 1653N48492D C Applicator · Brentwood, CABuilt 1976 · S/N 47BN48494Lewis Flying & Maintenance Svc · Morse, LABuilt 1976 · S/N 48BN48505Koch Richard N · Le Roy, MNBuilt 1976 · S/N 56BN48518Registered aircraftN-number assigned, not yet registeredS/N 61BN48519Buntings Dusting Inc · Berlin, MDBuilt 1976 · S/N 42BN48524Mamuzich Robert J DBA · Deming, NMBuilt 1976 · S/N 1661N48534Ag Aviation Service Inc · Elkhorn, WIBuilt 1976 · S/N 65BN48542Buntings Dusting Inc · Berlin, MDBuilt 1976 · S/N 66BN48547Magnum Aviation LLC · Goff, KSBuilt 1976 · S/N 70BN48551Hershey Flying Service Inc · David City, NEBuilt 1976 · S/N 71BN48555Milnor Agair Inc · Milnor, NDBuilt 1976 · S/N 1671N48556Lewis Flying & Maintenance Service · Morse, LABuilt 1976 · S/N 1638N48559Fountain Inc · Moscow, IDBuilt 1976 · S/N 73BN48575Registered aircraftBuilt 1976 · S/N 1672N48582Triple F Flying Inc · Benton, PABuilt 1976 · S/N 1674N48613Crop-Aid Aerial Service LLC · Hillsboro, OHBuilt 1976 · S/N 1682N48614Red Willow Rescue Inc · Cooperstown, NDBuilt 1976 · S/N 86BN48625Albertson James M · Slocomb, ALBuilt 1976 · S/N 90BN4863Eagle Air Service LLC · Greenfield, INBuilt 1972 · S/N 1016N48635Ag Aviation Service Inc · Elkhorn, WIBuilt 1976 · S/N 1684N48643Snake River Logistics Inc · Ontario, ORBuilt 1976 · S/N 99BN48645Buntings Aerial Applications LLC · Berlin, MDBuilt 1984 · S/N 723BN48655Hershey Flying Service Inc · David City, NES/N 102BN48659Mcclung Aerial Spraying Inc · Big Springs, NEBuilt 1976 · S/N 104BN48664Mid Continent Aircraft Corp · Hayti, MOBuilt 1976 · S/N 105BN48672Schindler Rick M · Neligh, NEBuilt 1976 · S/N 108BN48675Hershey Flying Service Inc · David City, NEBuilt 1976 · S/N 109BN48677Ag Aviation Service Inc · Elkhorn, WIBuilt 1976 · S/N 111BN496YZumwalt B Joseph · Sheldon, ILBuilt 1962 · S/N 153N503YRegenald Michaud Aviation LLC · Willows, CABuilt 1965 · S/N 353N5048FSky Tractor Ag LLC · Scottsbluff, NES/N 62BN50626Sale Reported · Austin, TXSale reportedBuilt 1975 · S/N 1511N5070WEckles William Phillip · Holdenville, OKS/N 537BN5083Kramr David · Eagle Lake, TXBuilt 1973 · S/N 1115N513YBell Robert A Jr · Scotland Neck, NCBuilt 1962 · S/N 145N5149Rock Creek Leasing LLC · Sapulpa, OKBuilt 1973 · S/N 1123N515YMidwest Flying Service Inc · Elgin, NEBuilt 1962 · S/N 147N519YSummers Mark E · Tuckerman, ARBuilt 1962 · S/N 156N522YAdcock Colton L · Dustin, OKBuilt 1962 · S/N 159
Back to AD 89-18-02 R1