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.
N45058Red Cardinal Aviation LLC · Chantilly, VAN4505UYates Kenneth E · Meridian, MSN4506UBryson James D · Casstown, OHN45073Trailing Edge LLC · Elmira, NYN4507ETaylor John · Canaan, CTN45080Todd Doug A · Dewitt, IAN45082Long Robert D · Kinston, NCN4508MJanis Paul H · Anchorage, AKN4509CReams Thomas M · Panacea, FLN4509MNewburg Dale E · Rhome, TXN450RPParadise Boating Co · Chicago, ILN4510CAyres Vance · Harrison, ARN4510EScroggin Gregory K · Minnetrista, MNN4510UOrsak Chris L · Seymour, TXN45112Iaba LLC · Norfolk, VAN45115Jiang Jun · Fremont, CAN4511MSleeper Ken L · Anchorage, AKN45132Jamesweathers Robi J · Blaine, MNN4513CSlowpoke Air LLC · Palm Harbor, FLN4513EMigis James P · Shady Shores, TXN45143Fly Sky Ads LLC · Manalapan, NJN4514EThomas Kevin L · Presho, SDN45156Flight Training Solutions LLC · Longwood, FLN4515ELewis Charles D · Lincoln, NEN45166Jet Life LLC · Coconut Creek, FLN45169Carlisle Elizabeth L · Mohnton, PAN4516CStahlman Michael J · Portland, ORN4516EHenderson Beverly A · Sharon Springs, KSN4516MSatran Laurel L · Detroit Lakes, MNN4516USteelman Aviation LLC · Montague, CAN45170Smits Joel R · Crete, ILN4517CHainline Thomas D · Sumter, SCN4518CLongden Earl W · Spirit Lake, IDN45190Violette Colin E · Rough And Ready, CAN45198Ebe Aviation LLC · Urbandale, IAN451LFrasca Lucille A · Urbana, ILN45203November 45203 LLC · Waterbury Center, VTN4520EDean Hank · Texarkana, ARN4521URodriguez Sergio · Rancho Cucamonga, CAN4522CEvans Michael R · Nome, AKN4523Thompson Michael P · Natchez, MSN45230Zutter Regan James · Hooper, UTN45235Grimes James R · Carlton, GAN45237Defrees Brooks H · Boulder, CON45243Keas Kirby Clay · Lakeway, TXN45245Rimar Dale S · Boca Raton, FLN45246Carlsen Brent R · Rochester, MNN45247Airgo Inc · Centralia, ILN4524CMcateer Kristina · East Greenwich, RIN4524UJennett Chris · Hudson, FL
Back to AD 94-05-05 R1