AD 2002-16-07
Registered aircraft · 985
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:2002-16-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-16-07')
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:2002-16-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-16-07') 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.
N173LMCopper City Aviation Services LLC · Bisbee, AZN174LMRasmussen Gregory · Floyds Knobs, INN175PMMoulton William M · Meredith, NHN1773CZollinger Duane C · Rittman, OHN177AXXim LLC · Columbia, MON177BKThompson Bruce G · Ithaca, NYN178ABDawson Daniel D · Princeton, IAN17KLWiers Keith R · Saint Albans, MEN17VPAvstar Inc · Seattle, WAN181ARGodbout Raymond J · Gorham, NHN181QKoerner Michael S · Rch Palos Vrd, CAN1826RHolsinger Kent H · Denver, CON185TUAdams Aviation Services Inc Trustee · Wilmington, DEN187KCSampson Air Services LLC · Queen Creek, AZN188RRStemen Randy · Canal Winchester, OHN18WCSale Reported · SigmaringenSale reportedN190GMMahon Gary · Winslow, ILN1914WSmitherman Roger · Choudrant, LAN192TUIasco Flight Training Inc · Redding, CAN1935CCarmean Todd R · Owasso, OKN194ABBriese Ronald R · Brandon, WIN1950SLammers Robert K · Oostburg, WIN195EARegistration Pending · Orem, UTRegistration pendingN1969GTucker Patrick A · Hopkinsville, KYN1971PSebesta Kenneth D · Boston, MAN1981BBurkhardt David A · Oregon City, ORN1985AJp Aero Holdings Inc · Kalispell, MTN199TUTwin Icarus LLC · Mount Juliet, TNN19VMRegistration Pending · Colorado Springs, CORegistration pendingN1BASeawings LLC · Saint Petersburg, FLN1DLThunderbird Aviation LLC · Littleton, CON2006KHelicorp Mro LLC · Dover, DEN2018Experimental Aircraft Assn Inc · Oshkosh, WIN202XSDurney Alan Nelson · Santa Clarita, CAN20386Burlingame Ralph H Jr · Mound, MNN204PHHartunian Robert T · Fawnskin, CAN204RDMastropietro Richard · Aptos, CAN205DHPhelps Jay R · Somerville, ALN206ZMVeterans Edge Aviation LLC · Las Vegas, NVN208MBramlett David M · Tucson, AZN208XIdahoxray LLC · Saint Anthony, IDN20KFMorel Paul F · Locust Grove, GAN2116MHenshaw Calvin T · Clermont, FLN211KAKlinefelter Kevin J · Bishop, CAN211SFYuriy Koziy · Massapequa, NYN212EASavage David · N Richlnd Hls, TXN212LHRegistration Pending · Wht Sphr Spgs, MTRegistration pendingN212XWittstruck Ivan W Jr · Greeley, CON2155AFerguson Darrell W · Acton, MEN215AAFinneyfrock Arthur · Huddleston, VA
Back to AD 2002-16-07