AD 83-18-01

Registered aircraft · 86

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:83-18-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-18-01')
  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.

N4344SFallon Mike · Tom Bean, TXBuilt 1975 · S/N 300-0024N4350SAura LLC · Elsie, MIBuilt 1976 · S/N 301-0030N4351SSales Joe H · Seminole, TXBuilt 1976 · S/N 301-0031N4370SGoat Rancho LLC · Euless, TXS/N 301-0050N4397SJohnson Kendall M · Wolf Point, MTS/N 301-0057N4401SSilver Wings Flying Company LLC · Olympia, WABuilt 1975 · S/N 301-0061N4403SSilver Wings Flying Company LLC · Olympia, WAS/N 301-0063N4422SSouther Field Aviation Inc · Americus, GAS/N 301-0082N4426SCrop-Serv Inc · Meade, KSBuilt 1977 · S/N 301-0086N4440SAeschliman Arlie W · Tribune, KSBuilt 1977 · S/N 301-0100N5017SDefenbaugh Matthew J · Biggsville, ILS/N 301-0106N5050SSimpson Don DBA · Bryan, TXBuilt 1977 · S/N 301-0110N5070SEldringhoff Jim · Wecota, SDBuilt 1977 · S/N 301-0111N5073SHughes Todd R · Rocky Ford, COBuilt 1978 · S/N 301-0113N5079SNish Robert M · Spearman, TXBuilt 1978 · S/N 301-0116N5236SMorrison Lynn · Vernon, TXBuilt 1978 · S/N 301-0130N5238SHayton James B · Sedro Woolley, WABuilt 1978 · S/N 301-0132N550BHWoodley Aerial Leasing LLC · Walnut, ILS/N 302-0184N69WNAg Air Services LLC · Walla Walla, WABuilt 1988 · S/N 301-0683N7305GAerial Ag Services LLC · Hillsboro, TXBuilt 1985 · S/N 301-0603N7306LMehling Robert C · Hardin, MTBuilt 1985 · S/N 301-0607N7307YRoseau Ag Inc · Georgetown, MNBuilt 1985 · S/N 301-0615N7308WNeal Aircraft Inc · Slaton, TXBuilt 1986 · S/N 301-0641N7309DFarm Air Inc · Astoria, ILBuilt 1986 · S/N 301-0642N7309ZMccormick Monty C · Lubbock, TXBuilt 1986 · S/N 301-0645N73110Lofton Aviation Inc · Georgetown, MNBuilt 1986 · S/N 301-0660N8511SKubecka Donald P · Seminole, TXBuilt 1978 · S/N 301-0134N8586SR & D Leasing Inc · Lemoore, CABuilt 1978 · S/N 301-0152N8590SUltra Ag Cropdusters LLC · Le Mars, IABuilt 1978 · S/N 301-0156N8595SHeadwaters Flying Service LLC · Three Forks, MTBuilt 1978 · S/N 301-0159N8608SMid Continent Aircraft Corp · Hayti, MOBuilt 1978 · S/N 301-0164N8639SBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 301-0169N8753SGilbreath Tony C DBA · Olustee, OKBuilt 1979 · S/N 301-0182N8829SHaynes Barry B · Chillicothe, TXBuilt 1979 · S/N 301-0208N8864SCrop Doctor Aviation Inc · Hill City, KSBuilt 1979 · S/N 302-0218N8886SHayton James B · Sedro Woolley, WABuilt 1979 · S/N 301-0227
Back to AD 83-18-01