AD 2000-11-05

Registered aircraft · 137

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

N31691Slaughter Don Wayne · Farmville, NCBuilt 1985 · S/N 301-0585N3169AWakefield William F · Devils Lake, NDBuilt 1984 · S/N 301-0567N3169DClassic Arrow Inc · Hutchinson, MNBuilt 1984 · S/N 301-0569N3169UWhitten Flying Service Equipment LLC · Snook, TXBuilt 1984 · S/N 301-0577N3648SSale Reported · Page, NDSale reportedS/N 301-0231N3650YWerth Lance C · Johnson Lake, NES/N 301-0253N3653YPhoenix Equpiment Lc · Nickerson, KSS/N 301-0275N36542Harris Spraying Inc · Circle, MTBuilt 1980 · S/N 301-0310N3654NCountry Air Service Inc · Hecla, SDS/N 301-0289N3658UBonner Aerial Applicators Inc · Summerdale, ALBuilt 1981 · S/N 301-0335N3659DAnf Air Service Inc · Garwood, TXBuilt 1981 · S/N 301-0327N3659TAura LLC · Elsie, MIBuilt 1981 · S/N 301-0329N3660CAero Charter Express Inc · Bismarck, ILBuilt 1980 · S/N 301-0324N3660TNorth Texas Dusters & Sprayers Inc. · Gainesville, TXBuilt 1981 · S/N 301-0336N401BMBart'S Flying Service Inc · Storm Lake, IABuilt 1992 · S/N 401-0853N401CWDakotawild Aviation Inc · Westhope, NDBuilt 1992 · S/N 401-0870N401KREast Air Aviation LLC · Cullman, ALBuilt 1991 · S/N 401-0813N401THAerial Ag Services LLC · Hillsboro, TXS/N 401-0875N4052PRadium Inc · Warren, MNBuilt 1985 · S/N 301-0605N408ACOver & Under Flying Service Inc · Winamac, INBuilt 1993 · S/N 4010921N409BRMehling Robert C · Hardin, MTS/N 4010909N4326SMarlow Aviation LLC · Lamoni, IAS/N 301-0006N4332SBonner Irma L · Robertsdale, ALBuilt 1975 · S/N 301-0013N4350SAura 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-0100N45116Macys Flying Service Inc · Tulelake, CABuilt 1990 · S/N 401-0752N4513WForest Flying Services Inc · Langdon, NDS/N 401-0754N4535UCga Holdings LLC · Kalispell, MTS/N 401-0773N45368Atlantic Ag Aviation Inc · Felton, DEBuilt 1990 · S/N 401-0775N4539BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0763N4539YHylands Agricultural Services LLC · Gretna, NES/N 401-0779N45421Ascend Ag Inc · Wall, SDS/N 401-0786N4547QFarm Air Inc · Quanah, TXS/N 401-0792N45492Woodley Aerial Leasing LLC · Walnut, ILBuilt 1991 · S/N 401-0801N4549EVertical Vegetation Management LLC · Darlington, INS/N 401-0765N4556WVersaair Services LLC · Overland Park, KSBuilt 1991 · S/N 401-0817N5017SDefenbaugh Matthew J · Biggsville, ILS/N 301-0106N501BRJohnson Airspray Inc · Argyle, MNS/N 501-0123N5050SSimpson 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-0130
Back to AD 2000-11-05