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.

N5236Porter Flying Service Inc · Chico, CAS/N 1130N5249Petersen Conrad H · Kenmare, NDBuilt 1973 · S/N 1131N524YSouthwind Aviatin Inc · Maryville, TNBuilt 1962 · S/N 161N5272Lanier John L Jr · Madison, ALS/N 652N5275Flying D Farm Inc · Kerhonkson, NYS/N 561N5279Vanderwaal Shane J · Junction City, WIBuilt 1968 · S/N 564N5286Slikker Flying Service Inc · Buttonwillow, CABuilt 1968 · S/N 562N5291Sky Aviation Corp · Worland, WYBuilt 1968 · S/N 572N5301P M Dusters Inc · Durham, CABuilt 1969 · S/N 590N5303Valley Sprayers Inc · Park River, NDBuilt 1969 · S/N 577N531MCJones Aviation Inc · Biggs, CABuilt 1978 · S/N 7CN5327Farm Air Inc · Astoria, ILBuilt 1969 · S/N 595N5335Williams Ag Service · Biggs, CABuilt 1969 · S/N 603N5337Mcdonald Jake V · Bowling Green, MOS/N 628N5344Graf Eric L · Dolores, COBuilt 1969 · S/N 619N5346Lanier Flying Service Inc · Madison, ALBuilt 1969 · S/N 643N5366Haynes Robert K · Pilot Point, TXBuilt 1969 · S/N 646N5368Cw Equipment Rentals Inc · Biggs, CABuilt 1969 · S/N 648N5369Ag Air II LLC · Scott, MSBuilt 1969 · S/N 649N5380Tall Towers Aviation Inc · Page, NDBuilt 1973 · S/N 1144N5395Avag Inc · Richvale, CABuilt 1973 · S/N 1149N5396Hershey Flying Service · David City, NEBuilt 1973 · S/N 1150N5412N5412 LLC · Shawnee, OKBuilt 1973 · S/N 1025N5416Nelson Flyers Inc · Louise, TXS/N 1030N5449Precision Ag Air LLC · Pendleton, INBuilt 1973 · S/N 1159N5450Growers Air Service · Woodland, CAS/N 1160N5470Atlantic Wings LLC · New Bern, NCBuilt 1973 · S/N 1166N5474Hershey Flying Service Inc · David City, NES/N 1172N54EZZavala Edward R · Tahoka, TXBuilt 1975 · S/N 1597N552YFarm Ag Enterprises LLC · Buckeye, AZS/N 223N558TJMorgans Flying Service LLC · Morse, LAS/N 458BN567JCChorman Spraying LLC · Milton, DEBuilt 1974 · S/N 1340N573AFWatson Air Farm LLC · Thibodaux, LABuilt 1979 · S/N 573BN591YWaterbury Craig A · El Paso, TXS/N 182N5KYCropair Flying Service · Cody, WYBuilt 1978 · S/N 377BN600JSRiggin Flight Service Inc · Madison, SDS/N 835N600TCarlson Cory R · Trail, MNBuilt 1969 · S/N 600N601YSouth Delta Aviation Inc · Fayetteville, ARBuilt 1963 · S/N 226N606YButte County Mosquito & Vector Control District · Oroville, CABuilt 1963 · S/N 229N608UHall William B · Vincentown, NJBuilt 1965 · S/N 337N613ULarson Lynn Robert · Casselton, NDBuilt 1965 · S/N 341N616UBarse William P · Hampstead, MDBuilt 1965 · S/N 344N622AGIngalls Aerial Sprayers Inc · Ingalls, KSS/N 622N62375Scott Flying Service Inc · Bono, ARBuilt 1988 · S/N 806BN633USmith David C · Brewster, WABuilt 1965 · S/N 369N63EAvag Inc · Richvale, CABuilt 1977 · S/N 305BN63WGrubbs Terry L · Gregory, SDS/N 3N640URegenald Michaud Aviation LLC · Willows, CABuilt 1965 · S/N 376N645YBarse William P · Hampstead, MDBuilt 1963 · S/N 234N6500KScott Flying Service Inc · Bono, ARBuilt 1977 · S/N 336B
Back to AD 89-18-02 R1