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.
N339ZSSeitzer Dale · Roseville, MNN33EPWilliams Jeffrey D · Florence, ALN341CBChichkov Dmitry · Sunnyvale, CAN341JAToga LLC · Cumming, GAN341JDRegistration Pending · Monroe, LARegistration pendingN342MFCommander Aircraft Services Inc · West Palm Beach, FLN342USUrva Aviation USA Corp · Pompano Beach, FLN344EADelaware Aircraft Trust LLC Trustee · New Castle, DEN344WPPapa LLC · Eufaula, ALN345HLLohmeyer Wayne D · Katy, TXN345KFKfa Aircraft USA Inc · Lewes, DEN3470SRicketts Michael D · Weirsdale, FLN347MBWilliams Michael David · Paducah, KYN349DNNorman Dave · Los Gatos, CAN34WFJohnston Aviation LLC · Melbourne Beach, FLN3503Registration Pending · Oxnard, CARegistration pendingN3503FYarbro Bruce Edwin · Poplar Bluff, MON3505DMeyer Bruce V · Largo, FLN3506LHinsz Cory · Spokane, WAN3512SJensen Brian S · Pahrump, NVN352RRKindred Douglas Wayne · Kennesaw, GAN353FMelbourne Flight Training LLC · Melbourne, FLN355NLLong Nicholas · Woodinville, WAN355USMelbourne Flight Training LLC · Melbourne, FLN356JJBarnes Justin · Belgrade, MTN356TNAukee Isaac · Ironwood, MIN357KCMostrong Michael C · Martinez Lake, AZN357PCFisher James C Jr · Calhoun, GAN357RWWren Rodney K · Hugo, OKN357VAKachemak Bay Flying Service Inc · Temple, TXN359RBCrenshaw Michael Page · Stayton, ORN359SMManning Scott G · Clewiston, FLN359WBNelson Daniel E · Fairfield, UTN361EXHangar 36 · Batavia, OHN361KFWatts Craig W · Incline Village, NVN363JAHeatwole Oren E · Dayton, VAN363XDiscovery Aviation Inc · Discovery Bay, CAN3656Amunategui Luis F · Shaker Heights, OHN3663CLange Joseph M · Fort Garland, CON366ASAtlantic Aviation International Inc · Lewes, DEN366HHShaklee Joel B · Brookline, NHN368LSPazara Timothy D · Channahon, ILN369TPSchley James R · Palmer, AKN36TLSzombathy Alkoto J · Pflugerville, TXN370WAPea-Wayman Flight LLC · Daytona Beach, FLN371JXPress Richard J · San Bernardino, CAN3721SSilvan Wayne C · Big Sandy, MTN372WSUpdoc Ventures LLC · Clinton, CTN3739KSobota Mark S · Bethlehem, PAN373USMelbourne Flight Training LLC · Melbourne, FL
Back to AD 2002-16-07