AD 2002-16-26
Registered aircraft · 554
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-26')
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-26')
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-26') 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-26') 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.
N1688BChen Chris · Monrovia, CAN168MBNemec David M · Helendale, CAN16BAOwen Aviation Co LLC · Meridian, MSN16BMWilson Joshua A · Mckinney, TXN172LMBristol Todd J · Mesa, AZN173LMCopper City Aviation Services LLC · Bisbee, AZN174LMRasmussen Gregory · Floyds Knobs, INN175PMMoulton William M · Meredith, NHN177BKThompson Bruce G · Ithaca, NYN17VPAvstar Inc · Seattle, WAN181ARGodbout Raymond J · Gorham, NHN1826RHolsinger Kent H · Denver, CON18WCSale Reported · SigmaringenSale reportedN1914WSmitherman Roger · Choudrant, LAN1950SLammers Robert K · Oostburg, WIN1971PSebesta Kenneth D · Boston, MAN1981BBurkhardt David A · Oregon City, ORN1985AJp Aero Holdings Inc · Kalispell, MTN1DLThunderbird Aviation LLC · Littleton, CON202XSDurney Alan Nelson · Santa Clarita, CAN20386Burlingame Ralph H Jr · Mound, MNN204PHHartunian Robert T · Fawnskin, CAN204RDMastropietro Richard · Aptos, CAN206ZMVeterans Edge Aviation LLC · Las Vegas, NVN208XIdahoxray LLC · Saint Anthony, IDN20KFMorel Paul F · Locust Grove, GAN211KAKlinefelter Kevin J · Bishop, CAN212LHRegistration Pending · Wht Sphr Spgs, MTRegistration pendingN212XWittstruck Ivan W Jr · Greeley, CON216EBrede Brian K · Lincoln, NEN216PMBolinger Andy L · La Follette, TNN219GHBurrichter Steven · Scottsdale, AZN220TSCondor LLC · Ponte Vedra Beach, FLN221SHSewell David E · Humble, TXN222DPatterson Lawrence Jr · Tampa, FLN223PFScout Aerospace LLC · Greensboro, NCN226HCSafeway Aviation LLC · Richmond, TXN228FTCole Matthew Dewayne · Trenton, GAN228XMidgley Edward S · Sugar Grove, ILN22ZLDalley Eric · Salt Lake City, UTN232PMHangar 23a LLC LLC · Woodbury, MNN232SSHaynes John H · Gainesville, GAN2337RHigh Flight Services Inc · Miami, FLN2341RMagniflight LLC · Pensacola, FLN234HWThooft Marlowe · Russell, MNN237AECollins Alan M · Delta, CON239AWBrown Daniel J · Grinnell, IAN241AVRegistered aircraftN241GGThompson Tom III · Byers, CON2430RGreat Lakes Flyer LLC · Waxhaw, NC
Back to AD 2002-16-26