AD 2002-23-06
Registered aircraft · 16,325
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-23-06')
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-23-06')
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-23-06') 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-23-06') 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.
N114PBBernabucci Christian J · Mapleton, NDN114PMSundance Aviation · Morganton, NCN114PRC W 3 LLC · San Juan, PRN114PSPitts S2b LLC · Salinas, CAN114PWSiddiqu Shahid · Hampton, VAN114RCAsbury William A · Bridger, MTN114RMImmelman Leasing Company LLC · Lompoc, CAN114RRMdb 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, KSN114WMMaule Flight LLC · Nashville, INN114XTaft Plumbing Co Inc · Taft, CAN1151ZRenfro Michael W · Bethel, AKN11541Upskirt Aviation LLC · Fredericktown, MON1154XKelley Jay D · Lake Havasu City, AZN1155PN1155p Corp Trustee · Wilmington, DEN1157SDig2fly LLC · Sandpoint, IDN115CEDentate Equipment Leasing LLC · Belmont, MAN115CSBurger Aviation LLC · Brandon, MSN115DKN4471j LLC · Dover, DEN115DSOverly Christopher Daniel · Williamsport, OHN115DWMav LLC · Erie, CON115GTWahl John H · Rockwell City, IAN115HPCam Aviation LLC · Valparaiso, INN115JDC R Aviation Inc · Miami, FLN115JWFeric Drazen · Mesa, AZN115KTMulva Jonathan · De Pere, WIN115MDSpecial Orthogonal Group LLC · Dover, DEN115PFHigh Tech Metals Inc · Harrisburg, PAN115SJWolf Richard · Yerington, NVN115SZThree Greens LLC · San Jose, CAN115VSSei Vincent J · Albuquerque, NMN1161XBarnett Donald R · Atoka, TNN1165XLechtenberg Lance · El Dorado, KSN1165ZRegistration Pending · Las Cruces, NMRegistration pendingN116BKDacy Roy W · Rockport, TXN116GRegistration Pending · Sheridan, WYRegistration pending
Back to AD 2002-23-06