AD 94-05-05 R1
Registered aircraft · 26,232
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.
N7606XRegistered aircraftN76071Dickinson Harley Dean · Saint Paris, OHN76074Eaton Billy J · Bridgeport, TXN76075Dafoe Thomas B · Arbuckle, CAN7607TVantine Willard W III · Lexington, SCN7607XHall Douglas F · Pembine, WIN7608MInspiration Aviation LLC · Mesa, AZN7608XStanton Todd D · Plains, KSN76092Greer Charles R Jr · Denair, CAN76093Summers Dennis · Perry, OKN76095Kephart John M · Franklin, INN76099Perdue Adrian V · Denton, NCN7609MYoung Robert D · Georgetown, DEN7609THall Donald P · Anacortes, WAN760CAMcculloch Matthew L · Stoutland, MON76102Johnson Lawrence F · Anchorage, AKN76106Cooper John R · Tilton, NHN7610TDines Stephen R · Monument, CON76111Blake Joshua J · Detroit Lakes, MNN76113Denison Aviation Inc · Atlantic, IAN76114Tundra Aviation Inc · Casselton, NDN76117Miller Mason Keith · Tyler, TXN76120Sale Reported · Kalispell, MTSale reportedN76121Bolton Derwin B · Jacksonville, TXN76122Norbury Investments LLC · Boonville, MON76123Creative Strategies Inc · Lucasville, OHN76129Ziegler Corbyn Rose · Post Falls, IDN7612MHall Adam Patrick · Borrego Springs, CAN7612TBabcock Douglas O · Chesterton, INN76132Simonis Tadas · Toms River, NJN76136Brown Michael E · Anchorage, AKN76137Casson Thomas · Jacksonville, ILN76140Fun With Physics LLC · Ocala, FLN76146Larmon Larry · Valparaiso, INN76148Chase 13 LLC · Wilmington, DEN76149Pallas Justin · Portage, MIN76154Bayou Flight LLC · Parker, CON76155Beaver Valley Aircraft Maintenance LLC · New Carlisle, OHN7615TN Maple LLC · Kalispell, MTN7615XEagle Flight Inc. · Fremont, NEN76163Loncarevic Andrew M · Blue Ridge, GAN76169Mccann Michael Patrick · Daytona Beach, FLN7616MGriffin Robert L Jr · Washington, NCN7616UShepard Gregory W · Fort Myers, FLN76171Delta Ridge Farms LLC · Oak Grove, LAN76174Hinshaw Eric Carl · Lake Wales, FLN76179Grismer Jeff Trustee · Hemet, CAN7617URikki Air LLC · Clarksville, TXN76180Moehn Dennis H · Oshkosh, WIN76186Wells Kris G · Barron, WI
Back to AD 94-05-05 R1