AD 2002-19-03
Registered aircraft · 12,723
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-19-03')
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-19-03')
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-19-03') 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-19-03') 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.
N114CTTairex Inc · Wilmington, DEN114DFNorthwoods Distribution Services Inc · Rhinelander, WIN114DWLayman Nathan L · Hudson, WIN114EEEngstrom Eric R · Eastover, NCN114ELNaperville Flying Club · Woodridge, ILN114FFCoastal Development Group LLC · Boca Grande, FLN114GTEnders Richard A · San Bernardino, CAN114HPDolanair LLC · Coal Valley, ILN114JAWright Richard D · Acworth, GAN114JGMack Phillip B · Tampa, FLN114JTVanbeek Donald Eugene · Tualatin, ORN114KR H Welsh LLC · Crescent City, FLN114KJRegistered aircraftFirst renewal noticeN114KLKaruppannan Venkatachalam · Troy, MIN114LRegan Properties LLC · Coeur D Alene, IDN114MBCrew Andrew P · Chester, CTN114MDUrsic Albert J · Minden, NVN114MGW F Carter Construction Inc · Arlington, TXN114MKGood Thomas Ryan · Grapevine, TXN114MTSattig Henry B II · Cortez, CON114MVMillin Andrew · Kalamazoo, MIN114PBBernabucci Christian J · Mapleton, NDN114PMSundance Aviation · Morganton, NCN114PRC W 3 LLC · San Juan, PRN114PWSiddiqu Shahid · Hampton, VAN114RCAsbury William A · Bridger, MTN114RRMdb Air LLC · Poway, CAN114RWLaw C Scott · Oklahoma City, OKN114SACustom Air International LLC · Homestead, FLN114SGMixon Christopher L · Lafayette, LAN114SJMeashey Matthew · Wake Forest, NCN114SMColvin Daniel A · Dayton, TNN114SRSkymaster Stc LLC · Mena, ARN114SSHeritage Air LLC · Scappoose, ORN114TBWelch D Michael · Foster City, CAN114TCIntegritas Forum LLC · Sundance, WYN114TLLa Soplaera Realty LLC · Niwot, CON114USPeters Richard A · San Marino, CAN114VCStevenson Andy · Boyd, TXN114VFAtticus Talon LLC · Wilmington, DEN114WCMahan Dusty · Cookeville, TNN114WEL & K Aviation Holdings LLC · Leavenworth, KSN1151ZRenfro Michael W · Bethel, AKN1154XKelley Jay D · Lake Havasu City, AZN1155PN1155p Corp Trustee · Wilmington, DEN1157SDig2fly LLC · Sandpoint, IDN115BRJp Air LLC · Rockledge, FLN115CEDentate Equipment Leasing LLC · Belmont, MAN115CSBurger Aviation LLC · Brandon, MSN115DKN4471j LLC · Dover, DE
Back to AD 2002-19-03