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.
N304PBMcgehee Aviation Services LLC · Zephyrhills, FLN304PPArrington Ray · Jackson, MIN30628Zollinger Rudolph A · Rittman, OHN311DZSawaf Darius · Dallas, TXN3143SStafford Marlin C · Patterson, GAN3173PHalberg Bill R · Battle Ground, WAN31750Yeats Chris P · Collinsville, OKN31EEJudd Tharon · Orem, UTN321HCLinda Vista Aviation Inc · West Palm Beach, FLN322PZUsibelli Joseph E · Fairbanks, AKN330BLCentral Seaplanes LLC · Cleveland, OKN333VTCanfield Dan · Ephrata, WAN334QHuitema Tom P · Portage, MIN3372Sky West Aviation Inc Trustee · Albuquerque, NMN337SELee Mark J · Arlington, WAN339PDWhiteley James N · Reno, NVN33EPWilliams Jeffrey D · Florence, ALN341CBChichkov Dmitry · Sunnyvale, CAN344WPPapa LLC · Eufaula, ALN345HLLohmeyer Wayne D · Katy, TXN345KFKfa Aircraft USA Inc · Lewes, DEN3470SRicketts Michael D · Weirsdale, FLN349DNNorman Dave · Los Gatos, CAN34WFJohnston Aviation LLC · Melbourne Beach, FLN3503Registration Pending · Oxnard, CARegistration pendingN3505DMeyer Bruce V · Largo, FLN3512SJensen Brian S · Pahrump, NVN355NLLong Nicholas · Woodinville, WAN356JJBarnes Justin · Belgrade, MTN357KCMostrong Michael C · Martinez Lake, AZN361EXHangar 36 · Batavia, OHN361KFWatts Craig W · Incline Village, NVN363JAHeatwole Oren E · Dayton, VAN3656Amunategui Luis F · Shaker Heights, OHN3663CLange Joseph M · Fort Garland, CON366ASAtlantic Aviation International Inc · Lewes, DEN36TLSzombathy Alkoto J · Pflugerville, TXN370WAPea-Wayman Flight LLC · Daytona Beach, FLN371JXPress Richard J · San Bernardino, CAN372WSUpdoc Ventures LLC · Clinton, CTN3739KSobota Mark S · Bethlehem, PAN373USMelbourne Flight Training LLC · Melbourne, FLN377KMFrick Gary A Trustee · Marion, INN377NXHall Ralph W · Wichita, KSN377WBG-Dawg LLC · Highlands, NCN378DTMinor Timothy Stephens · Jefferson, PAN37TPParkhurst Thomas G · Guilford, NYFirst renewal noticeN387NRegistration Pending · Leavenworth, KSRegistration pendingN389DBBurch David · Grant Township, MIN38PBExtreme Air LLC · Santa Barbara, CA
Back to AD 2002-16-26