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.
N2644NMcphee Charles E · Hartford, NYN2645LMchugh Eric P · Cleveland, TXN2645VPapp Adam · Raleigh, NCN2646Sliger David W · Floral City, FLN2646NChester Darren D W · Sioux Falls, SDN2646UEarly Patricia A · Palmyra, PAN2646VEsslinger David F · Zionsville, INN2647JHumble Tony R · Signal Mountain, TNN2647LCommonwealth Aviation Services LLC · Herndon, VAN2648JColonial Air Inc · New Bedford, MAN2648LZangs William J · Poplar Grove, ILN2648URock Kenneth L · Petersburg, AKN2649NKennedy John E · Henrico, NCN2649UMorrison Kent · Mccleary, WAFirst renewal noticeN2650DBrekke Aviation Inc · Edmore, NDN2650JNoll Cheryl A · Franklin, NCN2650LRholetter Eric W · Westminster, SCN2651KRegistration Pending · Camden, SCRegistration pendingN2651LJohnson Turner C II · England, ARN2652DScheidler Jerome P · Greensburg, INN2652LSullivan James M · East Wakefield, NHN2652NRounds Chris DBA · Waller, TXN2653KRedd Alan E · Sacramento, CAN2653UClark Nikita C · Ontario, ORN2654KHalstead George · E St Louis, ILRegistration revokedN2654LGriner Carrie L · Auburndale, FLN2655NLetourneau David W · Valencia, CAN2656JSperling Gabriel E · Silverdale, WAN2656LSzymanski Alexander G · Hernando, MSN2656VMccurdy James Rodney · Statesville, NCN2657DBouvrie Lukas J · Boulder, CON2657USzymanski Janet M · Alanson, MIN2658JLife Finds A Way LLC · Sarasota, FLN2658VGriffin Robert L · Warren, OHN2660KKienholz Lisa F · Los Angeles, CAN2660NMoment Lisa A · Urbana, ILN2661DWhite Theodore F · Willow, AKN2661KWalton T Michael · Hudson Falls, NYN2661LHall David B Jr · Midland City, ALN2661UMoret Ronald P · Los Osos, CAN2661VParker Alan A · Visalia, CAN2662DReakoff Jack L · Wiseman, AKN2662EDay Ralph · Jasper, ARN2662JHanel Bruce · Placerville, CAN2662LWaller Leslie P · Cynthiana, KYN2662UDeal Sarah M · Saint Joseph, MIN2663DGuy Gary L · Fairbanks, AKN2663UBas Part Sales LLC · Greeley, CON2663VGuthrie Michael E · North Highlands, CAN2664DGee Ryan S · Luverne, MN
Back to AD 94-05-05 R1