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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N31691Slaughter Don Wayne · Farmville, NCN3169AWakefield William F · Devils Lake, NDN3169DClassic Arrow Inc · Hutchinson, MNN3169UWhitten Flying Service Equipment LLC · Snook, TXN3648SSale Reported · Page, NDSale reportedN3650YWerth Lance C · Johnson Lake, NEN3653YPhoenix Equpiment Lc · Nickerson, KSN36542Harris Spraying Inc · Circle, MTN3654NCountry Air Service Inc · Hecla, SDN3658UBonner Aerial Applicators Inc · Summerdale, ALN3659DAnf Air Service Inc · Garwood, TXN3659TAura LLC · Elsie, MIN3660CAero Charter Express Inc · Bismarck, ILN3660TNorth Texas Dusters & Sprayers Inc. · Gainesville, TXN401BMBart'S Flying Service Inc · Storm Lake, IAN401CWDakotawild Aviation Inc · Westhope, NDN401KREast Air Aviation LLC · Cullman, ALN401THAerial Ag Services LLC · Hillsboro, TXN4052PRadium Inc · Warren, MNN408ACOver & Under Flying Service Inc · Winamac, INN409BRMehling Robert C · Hardin, MTN4326SMarlow Aviation LLC · Lamoni, IAN4332SBonner Irma L · Robertsdale, ALN4350SAura LLC · Elsie, MIN4351SSales Joe H · Seminole, TXN4370SGoat Rancho LLC · Euless, TXN4397SJohnson Kendall M · Wolf Point, MTN4401SSilver Wings Flying Company LLC · Olympia, WAN4403SSilver Wings Flying Company LLC · Olympia, WAN4422SSouther Field Aviation Inc · Americus, GAN4426SCrop-Serv Inc · Meade, KSN4440SAeschliman Arlie W · Tribune, KSN45116Macys Flying Service Inc · Tulelake, CAN4513WForest Flying Services Inc · Langdon, NDN4535UCga Holdings LLC · Kalispell, MTN45368Atlantic Ag Aviation Inc · Felton, DEN4539BWoodley Aerial Leasing LLC · Walnut, ILN4539YHylands Agricultural Services LLC · Gretna, NEN45421Ascend Ag Inc · Wall, SDN4547QFarm Air Inc · Quanah, TXN45492Woodley Aerial Leasing LLC · Walnut, ILN4549EVertical Vegetation Management LLC · Darlington, INN4556WVersaair Services LLC · Overland Park, KSN5017SDefenbaugh Matthew J · Biggsville, ILN501BRJohnson Airspray Inc · Argyle, MNN5050SSimpson Don DBA · Bryan, TXN5070SEldringhoff Jim · Wecota, SDN5073SHughes Todd R · Rocky Ford, CON5079SNish Robert M · Spearman, TXN5236SMorrison Lynn · Vernon, TX
Back to AD 2000-11-05