AD 94-05-05 R1
Registered aircraft · 26,230
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.
N9841MMusser Alvin M Jr · Memphis, MON98425Byrne David P · Ojai, CAN9843TPrzygoda Raymond C · Pinckneyville, ILN9843XTidwell Gregery D · Modesto, CAN98445Dorman Dan C · Kodiak, AKN98453Miller Gerald E · Converse, TXN9845MRichardson Ronald W Trustee · Stewartville, MNN9845TGilbert Lawrence E · Titusville, FLN9846MSchrull Robert E · Brattleboro, VTN98473Hughes Coby D · Collinsville, OKN9848TMueller Scott A · Garden Prairie, ILN98495Anderstedt Richard A · Clearwater, MNN9849TRushing Kevin W · Marks, MSN98501Blair Geary L · Weatherford, TXN98503Cub 503 Inc · Georgetown, MEN98509Swanton Peter K · Willits, CAN9850MCopeland Tyler G · Prineville, ORN9851JPlanepower LLC · Meridian, MSN9851YElliott Carlton P Jr · Rustburg, VAN9852JG & M Associates LLC · Quitman, GAN9852TRead Colin L · Plattsburgh, NYN9852YMingo Daniel J Trustee · Wasilla, AKN98538Rular LLC · Remington, VAN98548Taylor Bryan H · Elizabethtown, NCN9854JAdams James P · Wilbraham, MAN9854TMcdowell Bryan D · Blooming Grove, TXN98555Callis Robert S · Bedford, KYN98558Transitional Technology Inc · Lafayette, LAN9855TJkc Farm LLC · Chinook, MTN98576Seminole Lake Cub Club LLC · Clermont, FLN9857BSouthern Aircraft Consultancy Inc Trustee · Casper, WYN9857JReiss Alan T · Puyallup, WAN9858MUpton James · Guthrie, OKN9858TPollick James J · Frankenmuth, MIN9858YMclaughlin Paul E · Mansfield, OHN9859BMcfag LLC · Delaware, OHN9859JNghiem Daniel · Westminster, CAN9859TFox Gary J · Buffalo, NYN985KKHutto Azel J III · Lexington, SCN98600Reeder Thomas · Union Hall, VAN98608Gritter Richard J · Catlett, VAN9861Fadeley Kenton D · Fernandina Beach, FLN9861TMott Joseph · Arvada, CON9862BSunny Flying LLC · Kindred, NDN9862TGrosgerbauer Bryan · Ogden, UTN9863DStacy Richard K · Moneta, VAN9863TBacklund Scott W · Greybull, WYN9864JCottrell James · Mililani, HIN9864TN9864t LLC · Pawleys Island, SCN98656Rankin Kevin J · Maryville, MO
Back to AD 94-05-05 R1