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.
N375JRReynolds Jeff · Port Orange, FLN375TSKrips Jack E Jr · Winter Park, FLN376GSEverythingtonothing Studios LLC · Las Vegas, NVN377KMFrick Gary A Trustee · Marion, INN377NXHall Ralph W · Wichita, KSN377WBG-Dawg LLC · Highlands, NCN378DTMinor Timothy Stephens · Jefferson, PAN37TPParkhurst Thomas G · Guilford, NYFirst renewal noticeN380SSLockheed Martin Aeronautics Co · Lancaster, CAN3849ALange Daniel M · Whitewater, WIN386USAb Prop Plane I LLC · Metairie, LAN387NRegistration Pending · Leavenworth, KSRegistration pendingN388SGLeinberger Gary · Lancaster, PAN389DBBurch David · Grant Township, MIN38PBExtreme Air LLC · Santa Barbara, CAN390GLSidlinger Computer Corp · Flagstaff, AZN3924VParelli Pat · Reddick, FLN394USWings Over Texas Holdings LLC · Denton, TXN396SFunfsinn John J · Peru, ILN397MTMelbourne Flight Training LLC · Melbourne, FLN398AAWings Over Texas Holdings LLC · Denton, TXN398CDBarnes Ralph R · Cocoa, FLN398RCChristopherson Rodney V · Williamsburg, MIN398UAAb Prop Plane I LLC · Metairie, LAN3993Registration Pending · Fort Worth, TXRegistration pendingN39RRMesa Airlines Inc · Phoenix, AZN39RWDevecchio Andrew · Santa Fe, NMN400PZAerotech Aviation LLC · Sidney, OHN400SPKaplan Asher H · Tucson, AZN4010EKitty Hawk Flight School LLC · Kill Devil Hills, NCN401HAKitty Hawk Flight School LLC · Nags Head, NCN402EDCason Sean R · Bryson, TXN402HAKitty Hawk Flight School LLC · Nags Head, NCN402WMoore Brian J · Lancaster, CAN404KBBrady Kenneth · Santa Fe, TNN4058UEliasen Anthony J · Carthage, MON405CHGleason William J · Coudersport, PAN406SSCox Tim Ray · Waldron, ARN406WSMorris Milton L · Pierre, SDN409JDStern Robert J · Alpine, WYN40CPAircam 40cp LLC · Wilmington, DEN40PBExtreme Air LLC · Santa Barbara, CAN41089Rodewald Ryan · Umatilla, FLN410TMCass Brian O · Raleigh, NCN411BDFort Charles W Jr · Show Low, AZN4123PBroce Donald S · Rosamond, CAN412PLFischer Joachim W · Foothill Ranch, CAN413FJefts Larry G · Kunia, HIN413WHZiegler Aviation LLC · Minneapolis, MNN414RHCity Of Tomball · Tomball, TX
Back to AD 2002-16-07