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.
N2417BRamsay Danny M · San Antonio, TXN2417LBox Aviation Inc · Montgomery, ALN2417NZanuzoski Alan K · Hillsboro, ORN2418DRogers Colin · Nevada City, CAN2418LF Sharp Aviation LLC · New Baltimore, MIN2418UGronning Chris D · Anchorage, AKN2419BFenn Michael J · Cloverdale, CAN2419DHansen Michael C · Roseville, CAN2419HPeterson Christopher A · Holt, FLN2419JScheller Dwain A · Grand Rapids, MIN2419KMccann Michael · Springfield, ORN2419L2419l LLC · Jackson, MIN2419YBaker Adam W · Germantown, TNN241NYColonial Aviation LLC · N Prince George, VAN241PFForsyth Huston J · New Orleans, LAFirst renewal noticeN241SBFowler Gerald M · Hernando, FLN2420DThomas Ryan J · Anchorage, AKN2420ECabelka David M · Wausau, WIN2420JRailsback Craig S · Huntington Beach, CAN2420UAylmer Debra L · Black Creek, GAN2421LPerdue Dustin W · Mooresville, INN2421UWiney Jonathan · Michigan City, INN2421YAzflygal LLC · Phoenix, AZN2422BRoki Classics LLC · Ogallala, NEN2422LTravis Equipment LLC · Bee Cave, TXN2422VKeilman Geary P · Las Vegas, NVN2423DWatkins Veronica J Trustee · Sparks, NVN2423JHarris Patrick S · Chamberlain, SDN2423KDarley Vernon O · Peachtree City, GAN2423LBig Hook Wilderness Camps LLC · Snowmass Village, CON2423UChord Line LLC · Homer, AKN2423VDtc Flying Club LLC · Sycamore, ILN2423YStevens Mark E · Virgilina, VAN2424KBlack Charles B · Lenoir, NCN2424LRoberts Steven R · Palo Verde, AZN2424YBeek Nigel A · Pembroke Pines, FLN2425VHathaway Ben · Corvallis, ORN2426DPalmer Bryon · Fall City, WAN2426KMoschell Randy Archie · Howard, SDN2426L588 Delta LLC · Seminole, OKN2426UMartin Odis Bruce · Whitney, TXN2426YShamrock Flying Club Inc · Millersville, PAN2427LT&T Aviators LLC · Buford, GAN2427VN2427v LLC · Southbury, CTN2428YYellen Mark A · Mohave Valley, AZN2429BRegistration Pending · Oshkosh, WIRegistration pendingN2429LCook Shawn R · Middlebury, VTN2429UNorman Jon Frederic Jr · Pineville, LAN2429VMoriarty Gerry J · Anchorage, AKN2429YTucker Robert A · Kingston, OH
Back to AD 94-05-05 R1