AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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.
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:94-05-05-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:94-05-05-R1') 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.
N82689Davis Jim F · Poteau, OKN8268AVelligan Gary S · Granada Hills, CAN8268FBudd Jim · Rushville, NEN8268XMarvin Ray · Tomahawk, WIN82693Gould Allison L · Antrim, NHN82699Koering Henry Marvin · Fort Ripley, MNN8269LOneal Gary L · Springdale, ARN826DWWoelbing Aviation LLC · Franksville, WIN8270SN83993 LLC · Cherry Hill, NJExpired dealerN8270TMathison John M · Fernley, NVN8270XWarfield Brett Michael · Cypress, TXN8271AGraybeal Jason W · Ocala, FLN8271SKontz Gary Lee · Canby, MNN8271XSadowski Curtis D · Taylorville, ILN8272LMarfull Eric · Roseville, CAN8272SVierheller Glenn Eric · Seville, OHN8272UCraig Harry L II · Buckhannon, WVN82730Scott Tabb E · Clyde, TXN8273BBlue Ribbon Aviation LLC · Oakland, MDN8273FAir Charterz LLC · Columbus, OHN8273TElliott Clay E · Gillette, WYN8273UWings Of Grace Ministries Inc · Melbourne, FLN82745Foley Michael W · Galt, CAN82747Hood Timothy G Jr · Morrison, ILN8274AOhler Michael Jr · West Richland, WAN8274FMcclain Daniel S · Enon Valley, PAN8274TTraylor Robert B · Millersview, TXN8275BVixie James G · Milton Freewater, ORN8275FStanford Michael · Victoria, TXN8275XEvans C David II · Elkhart, INN82768Beasley Charles A · Spencer, VAN8276BHermens Stanley G · Wallowa, ORN8276LFly Time Aviation LLC · San Tan Valley, AZN8276TCooper Craig S · Pasco, WAN8276UNurge Richard J · Gilroy, CAN8277BRyder Clifford J · Massapequa, NYN8277LSillers Kim O · Sault Sainte Marie, MIN8277UEdgewood Farms LLC · Groveland, NYN8278FIvey Joseph M · Poland, OHN8278UMattison Alan B · Petaluma, CAN8278XDepew Gerald R · Oak Ridge, TNN8279Winingar Thomas M · Brock, TXN8279AHadley Harold C · Parma, IDN8279TGaddis James W · Steelville, MON827DFBrown Edward M · Cabot, ARN82800Whitaker Alvin E · Waterloo, WIN82805Cheatham Paul · La Verne, CAN8280BSea Coast Aviation LLC · Conway, SCN8280CEllis Matthew W · Sabina, OHN8280TSwift Raptor Aviation LLC · Herndon, VA
Back to AD 94-05-05 R1