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.
N216EBrede Brian K · Lincoln, NEN216PMBolinger Andy L · La Follette, TNN216TUTecnam US Inc · Sebring, FLN219GHBurrichter Steven · Scottsdale, AZN220TSCondor LLC · Ponte Vedra Beach, FLN221LSWebb Jeffrey J · Fair Play, SCN221SHSewell David E · Humble, TXN221TCSchollmeyer Mike D · Dunn Center, NDN221WUtset Anthony · Okeechobee, FLN222DPatterson Lawrence Jr · Tampa, FLN222SCKathryn E Theiss Phd · Portland, ORN222YBCameron Chad E · Box Elder, SDN223PFScout Aerospace LLC · Greensboro, NCN223SThurber Raymond L · White Lake, MIN226HCSafeway Aviation LLC · Richmond, TXN228BMC2s2 Partners LLC · Chesapeake, VAN228FTCole Matthew Dewayne · Trenton, GAN228XMidgley Edward S · Sugar Grove, ILN229DCBowen David W · Tucson, AZN22ZLDalley Eric · Salt Lake City, UTN23183Nauti Services Inc · West Park, FLN232JWElswick Theodore B · Fernley, NVN232PMHangar 23a LLC LLC · Woodbury, MNN232SSHaynes John H · Gainesville, GAN2337RHigh Flight Services Inc · Miami, FLN2341RMagniflight LLC · Pensacola, FLN234HWThooft Marlowe · Russell, MNN234NXRising Wings Aviation Inc · Casper, WYN236SCHall Richard G · Egg Hbr Twp, NJN237AECollins Alan M · Delta, CON239AWBrown Daniel J · Grinnell, IAN240TUTecnam US Inc · Sebring, FLN241AVRegistered aircraftN241GGThompson Tom III · Byers, CON242TALevy Robert · Staunton, VAN2430RGreat Lakes Flyer LLC · Waxhaw, NCN245TASaltair LLC · Salt Lake City, UTN247MVSpitfire Ventures LLC · San Antonio, TXN247WTHansen Kevin Lee · Island Park, IDN2487NMacias Martin V · Yuma, AZN2489YKlimenko Eugene · Merrill, WIN248TATumbleweed Leasing Co Inc · Salt Lake City, UTN2491UOddie James W Trustee · Cerritos, CAN2495XYoder John D · Centreville, MIN2497HDuke David O · Arroyo Grande, CAN249MSBodrie Sean · Brighton, MIN24BZTwo Calf Cattle Company LLC · Winifred, MTN24ESGarris Joel Trustee · Los Angeles, CAN24PVMorris Douglas K · Huntsville, ALN24XDSummitt Air Corp · Wilmington, DE
Back to AD 2002-16-07