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.
N8430XMyers Glen · Grassy Butte, NDN8431GNordstrom Marc A · Bend, ORN8431MDavis Ronald J · Naples, FLN8431UNelson Burton · Cookeville, TNN84321Hintz Courtney N · San Antonio, TXN8432MStormswift Aviation LLC · Baltimore, MDN8432UHesse Paul W · Oxford, NCN8434UJwa Flight School LLC · Bolingbrook, ILN8434XKopp Jeffrey L · Menomonie, WIN8436Higgins Ryan · Hellam, PAN8436MFlabob Airport LLC · Riverside, CAN8436UClinton Aviation Corp · Clinton, ARN8437XHanshaw Joe W · Louisa, KYN8438JBlackwood Larry W · Elm Mott, TXN8438XThomas Marc R · Elizabethtown, PAN84393Poole David W · Indianapolis, INN8439USeeliger Jeremy E · Pasco, WAN8439XMonson Conrad · Wasilla, AKN8440UNicholls Donald B · East Amherst, NYN8440XMenozzi Elizabeth M · Eastsound, WAN84417Favell John P · East Bridgewater, MAN84418Brodine Alan H · Rochester, NYN8441JAviation Trust Co LLC Trustee · Oklahoma City, OKN84428Warner James B Jr · Lincoln, NEN8442BSouthern Aircraft Consultancy Inc Trustee · Casper, WYN8442GFoster Dustin · Dublin, VAN8442XReady Aim Flyer LLC · New Castle, DEN84430Huizenga Larry O · Minot, NDN8443GVon Wald Enterprises LLC · Glendale, AZN8443JThunderbolt Resourcing LLC · Warrensburg, MON8443UNapieralski Todd Allan · Chelsea, MIN84451Wyatt Maryellen Personal Represenentative · Weirsdale, FLN8446JBent James L Jr DBA · Palatine Bridge, NYN8446XSels Philip O · Magnolia, DEN84475Finn Michael R · Maple Grove, MNN8447XHill Gregory J · York, PAN8448GMidwest Aviation Services LLC · Kendallville, INN8448UGillis Christopher Paul · Fredericksburg, VAN8448XPritchard Jason T · Blaine, WAN8449BBrooks David P · Mantorville, MNN8449JSchaff James F · Gakona, AKN8449MCopper River Airmotive LLC · Copper Center, AKN844RLLindsey Ronnie N · Lexington, SCN844TSPaup Dennis C · Glidden, IAN8450MChoquette Marc J · Juneau, AKN8450UJust-Plane-Fun LLC · Searcy, ARN84517Knutson Wayne R · Tioga, NDN84519Adams Patrick A · Louisville, KYN8451MDelalat Shariar · San Diego, CAN8451XHorn Jamie D · Spicewood, TX
Back to AD 94-05-05 R1