AD 2016-14-05
Registered aircraft · 781
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:2016-14-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:2016-14-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:2016-14-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:2016-14-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.
N34CLBarrett Benjamin C · Gorham, MEN377RMDinucci Gino · Clearwater, FLN40184Stoots David A · Fairbanks, AKN406BNClover Crest II Inc · Key Largo, FLN416DCWeaver Eric W · Anchorage, AKN444REJenson Greg Ray · Pueblo, CON4450CC & C Auto Sales LLC · Atlanta, MON470HDChandler Dennis · Castroville, TXN470JBLong James · Lyman, WYN47KVCaron Robert M · Vero Beach, FLN5089Gifford David M · Las Vegas, NVN522JHMinor Steve A · Twain Harte, CAN525ZMMaba Aircraft Services Co · Vero Beach, FLN531VMcmillan Mark Gilbert · Oak Harbor, WAN540DHoopes Kristopher · Davis, OKN54973Szymanski Tadeusz C · Fort Myers, FLN58FAAlman Michael C · Fruitport, MIN59175Brown Charles A · Boise, IDN59YYBay Richard P · West Jordan, UTN5HVOppegard Nicholas D · Eagle River, AKN649ARSmith Roy Dennis · Buckeye, AZN6501ERobinson James W · Henderson, NVN6505EHeman Darrick L · Blue Springs, MON6506EArmstrong Bruce · Port Orchard, WAN6510EScherer Luis R · Kent, OHN6511EMckenna Francis · Granville, PAN6517ERed Baron LLC · Middletown, DEN6518EMozingo James C · Hernando, FLN6520ENichols Matthew Q · Maple Valley, WAN6521EWeaver Clifford A · East Berlin, PAN6523ESkeen Andrew · Lindon, UTN6524EWhite Wings LLC · Anchorage, AKN6527ETaylor Carey A · Rainier, WAN6532ERegistration Pending · Maize, KSRegistration pendingN6537EDittmer Michael C · Springtown, TXN6540EAerial Crop Care Co · Hebron, NDN6541EAkers Sean M · East Wenatchee, WAN6542EBond Ward Thomas · Salem, MON6544ESando Jan R · St Louis Park, MNN6546EMenard Keith L · Bellevue, TXN6549ENewton Donald H · Lewistown, MTN6551EMoore Henry J · Deer Park, WAN6557EClor Rosalee G · Saint Clair, MIN6559ECarlson Garrett R · Ramsey, MNN6560EAeschliman Arlie W · Tribune, KSN6563EWorld Aircraft Inc · San Antonio, TXN6564EAtcheson John R · Franklin, GAN6565EGeyer Brian E · Souderton, PAN6567EHastings Larry K · Lubbock, TXN6571ELersner Bradley D · Katy, TX
Back to AD 2016-14-05