AD 94-05-05 R1
Registered aircraft · 26,231
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.
N418BDHallack Daniel E · Hart, MIN418LJClement James G · Cresson, TXN418NSSalzl Aaron J · Elk River, MNN418WLShly Aviation LLC · Morgan, PAN4190FKelly-Hackett Kylie Kristine · Wilkeson, WAN4190LLutz Winfield G · Leeper, PAN4191FN4191f LLC · Kingsland, TXN4191LKelsey James R Sr · La Plata, MON4192FDavidson E Bryant Trustee · Owasso, OKN4192VMerren Trennon R · Brady, TXN4193LJaybird Flight LLC · Mesa, AZN41944Karnaukh Mikhail B · West Jefferson, NCN41947Von Wald Stephen A · Portland, ORN4195FDavolt John W · Hobe Sound, FLN4196FLabrie David L · Deland, FLN4197FFrizzell Joshua R · Mcdonough, GAN41984Brummell Reggie E · Pittsburg, TXN4198NCohen Marc A · Mason, WIN4198UMay David E · West Liberty, KYN41999Engler Eric M · Cass City, MIN4199FPena Edwin A · Mission Hills, CAN4199LSarkisian Arthur · Woodstock, GAN4199UTailwind Aviation LLC · Stafford, KSN419AKeech Paul A · Fairbanks, AKN419CALind William · Los Angeles, CAN419GBTorello Michael S · Port Huron, MIN419JFWatson John W · Chico, CAN41AFAmerican Airpower Heritage Flying Museum Inc · Dallas, TXN41BRRetka David L · South Saint Paul, MNN41CTPratt Roy J · Vienna, OHN41EZCoffman Douglas B · Pleasanton, KSN41MXJohnston Gabriel T · Grants Pass, ORN41PSouthern Aircraft Consultancy Inc Trustee · Casper, WYN41RMK & M Aviation LLC · West Liberty, KYN41TKHofeldt Jadrian B Trustee · Verona, WIN41TXHase Gary A · Fort Worth, TXN41WPSale Reported · Copper Center, AKSale reported, pending cancellationN42009Tomlinson A Scott · Carefree, AZN4200FVanhorne John W · Everett, WAN4200LDewey Michael C · Deer Island, ORN4200UPereira Jesse C · Medford, ORN42019Wilson Douglas W · Oxnard, CAN4201NLaverty Jerald · Laverne, OKN42023Leclercq Benoit · Saint Cloud, FLN42029Donalds Air Park Inc · Pantego, NCN4202UVlk Mark J · Odessa, WAN4203FWindham Air LLC · Oxford, FLN4203NHansen Loren E · Des Moines, WAN4203UZeller Vernon B · Boonville, MON4203VAmelia Reid Aviation LLC · Wilton, CA
Back to AD 94-05-05 R1