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.

N8958HShoemaker Joseph C Jr · Bridgeton, NJBuilt 1975 · S/N 1593N895XGustin Aviation Inc · Lewiston, IDBuilt 1965 · S/N 401N8960HCurry Timothy S · Salisbury, MDS/N 1595N8961HO'Brien'S Flying Service Inc · Iowa, LAS/N 3BN8962HVardaman Charles L · Howe, TXBuilt 1975 · S/N 1596N8967HAllen Chorman & Son Inc · Milton, DEBuilt 1975 · S/N 1599N896XMajor Ken'S Flying Service LLC · Colfax, NDBuilt 1967 · S/N 451N8974HReed Andrew DBA · Fostoria, MIBuilt 1974 · S/N 1347N8977HS & S Aviation LLC · Morse, LABuilt 1975 · S/N 1601N897XCw Equipment Rentals Inc · Biggs, CABuilt 1966 · S/N 419N8980HLeger Jeffery S · Beaumont, TXS/N 1603N90401Hershey Flying Service Inc · David City, NES/N 688N9041GHershey Flying Service Inc · David City, NES/N 464N9041MHouston Ag Flying Ser Inc · Owensboro, KYS/N 1703N909XAir Ag LLC · Milton, DEBuilt 1968 · S/N 501N910MGVincent Flying Service Inc · Kaplan, LABuilt 1995 · S/N 835BN915XTriple F Flying Inc · Benton, PABuilt 1967 · S/N 434N916XNoble Dennis G · Sutter, CABuilt 1967 · S/N 435N939XHughes Dale · Lake Arthur, LABuilt 1967 · S/N 453N943QCBenrud Aviation LLC · Rice, MNBuilt 1983 · S/N 711BN943XAdcock Colton L · Dustin, OKBuilt 1968 · S/N 506N949XValley Sprayers Inc · Park River, NDBuilt 1967 · S/N 463N955XHoltz Britton N · Clarksburg, CABuilt 1967 · S/N 469N961QCCentral Planes Aviation Inc · Sauk Centre, MNS/N 643-BN962QCAnderson Flying Service LLC · Covington, TNS/N 428BN9630Minturn Spraying Co Inc · Dillon, SCBuilt 1974 · S/N 1194N9632Davis Clinton B · Bakersfield, CABuilt 1974 · S/N 1196N963QCScott Flying Service Inc · Bono, ARS/N 638BN9640Harris Robert W · Covington, TNBuilt 1974 · S/N 1204N9650Hershey Flying Service Inc · David City, NES/N 1381N9677Slough Samuel H · Flora, MSBuilt 1974 · S/N 1215N9688Confederate Air Inc · Tillar, ARBuilt 1974 · S/N 1220N9694307 Aviation LLC · Worland, WYBuilt 1974 · S/N 1227N9709Nor Wes Inc · Shreveport, LABuilt 1974 · S/N 1233N9722Nelson Flyers Inc · Louise, TXBuilt 1974 · S/N 1226N972QCMark Gary Flying Service Inc · Inverness, MSBuilt 1973 · S/N 1125N9768Mid Continent Aircraft Corp · Hayti, MOBuilt 1974 · S/N 1254N9778Hanke Kenneth O · Clio, SCBuilt 1974 · S/N 1274N9782Evans Aviation Inc · Imlay City, MIBuilt 1974 · S/N 1261N9794Registered aircraftBuilt 1974 · S/N 1271N9799SHackberry Flying Service LLC · Caraway, ARS/N 1701N9805Petersen Conrad H · Kenmare, NDBuilt 1974 · S/N 1272N9809Chaffee James R · Meridian, CABuilt 1974 · S/N 1270N9816Davis Clinton B · Bakersfield, CABuilt 1974 · S/N 1281N9825Johnson Brian G · Goodridge, MNBuilt 1974 · S/N 1286N9827Ce Air Inc · Argyle, IABuilt 1974 · S/N 1287N9853Oregon Trail Air Service LLC · Nyssa, ORBuilt 1974 · S/N 1291N986XThompson Mark D · Edgewood, TXS/N 662N9874Tall-Towers Aviation Inc · Page, NDBuilt 1974 · S/N 1307N9892Redditt Air Service Inc · Cleveland, MSBuilt 1974 · S/N 1324
Back to AD 89-18-02 R1