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.
N410UCarey Calvin W · Evansville, WYN410WEBruno Christopher B · Eagle River, AKN4110LNeu Aviation LLC · Benton, LAN4110UKrul Donald · Center Line, MIN41116Sommer John J · Seattle, WAN4111EHeller Kurt L · Skwentna, AKN4111FRoss Karen F · Marion, TXN4111NMcgrath Connor W · Norfolk, VAN4111UKenner Matthew T · Big Canoe, GAN4111VJohnston Daniel T · Cambridge, OHN41122Minor James F · Lake Dallas, TXN4112FWard Leigh C · Garden Valley, IDN4112NLittfin Todd D · Eleva, WIN4112VButterfield Colin · Wellesley, MAN4113VHare Charles W · Leaf River, ILN41147Papp Jacob R · Fort Edward, NYN4114LLarson Lynn R · Casselton, NDN4114NFoster James W · Rapid River, MIN4114UPelan Lynn · Oakland, NEN4115FHogan Darrel R · Ash Grove, MON4115LPierce Michael W · Leitchfield, KYN4115UMoore David A · Winchester, TNN4116DLofstrom Caleb J · Wasilla, AKN4116LHubbard Matt · Phoenix, AZN4116NUnruh Adrian R · Bellevue, WAN41175Myers Randall · Parshall, NDN4117LPatrick Milan Jr · Shinnston, WVN4118FMountain Air Spray Co Inc · Craig, CON4118LUan Venture Partners LLC · Odessa, FLN4118UZaner Don D · Osceola, MON4119FPlymate Claude L · Tehachapi, CAN4119LSugar Aircraft LLC · Oak Harbor, WAN4119UWeeks Nathaniel J · Sartell, MNN411DEdwards Anthony C · Weaverville, CAN411FClement Robert D · Arizona City, AZN411RFFoothill Aircraft Sales & Service Inc · Upland, CAN4120EWilliams Barrett G · Homer, AKN4121FHarrold Bruce E · Greybull, WYN4121U150d LLC · Attica, NYN4122NSouthern Aircraft Consultancy Inc Trustee · Casper, WYN4123HEngler Eric M DBA · Cass City, MIN4124FNelson David R Co-Trustee · New Richmond, WIN4125ESmith John R · Greensboro, GAN4125FSale Reported · Addison, TXSale reportedN4125LEvans Samuel F · Selma, ALN4125UOxborrow Andrew Charles · Lake Barrington, ILN4126FRider Terry · Corinth, MSN4126LBritton Jeff J · Forest Falls, CAN41273Pa-18 LLC · Hood River, ORN4127FDavolt John E · Independence, KSFirst renewal notice
Back to AD 94-05-05 R1