AD 2002-23-19
Registered aircraft · 486
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-19')
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-19')
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-19') 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-19') 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.
N775STDxp Holdings Inc · Houston, TXN777Erebus LLC · Tampa, FLN77FWestrock Group LLC · Little Rock, ARN77QETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN783FSFarspo LLC · Oklahoma City, OKN785ADCs Investments LLC · Dallas, TXN787FRFurniture Row Leasing LLC · Denver, CON789JCMajjec Holdings LLC · Newark, DEN78FJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN790RTnc Management V LLC · Phoenix, AZN790Z2514 LLC · Dover, DEN793CGN793wf Lease LLC · Santa Ana, CAN793KKJc Aviation LLC · Tucson, AZN797HDMario Murillo Ministries · Lafayette, TNN797LDThomas Aviation LLC · Wichita, KSN797PGEndless Aviation LLC · Buna, TXN797TWMulti-State Realty Investments LLC · Yukon, OKN797WCLand Sea Air Leasing Corp · Sylmar, CAN799RBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN79TFBaron & Budd P C · Dallas, TXN800GHLeading Edge LLC · Minneapolis, MNN801WC986 Pb LLC · Portland, ORN801WWMountshore Capital LLC · Pompton Plains, NJN802CCOklahoma Steel & Wire Co LLC · Madill, OKN803PHPost Foods LLC · Chesterfield, MON805DBDb Service Company LLC · Centennial, CON808VJVee-Jay Equipment LLC · Clarkston, MIN80BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN80MHFalcon 2000 (Msn 108) Leasing LLC · New York, NYN80RPRich Aviation Inc · Buffalo, NYN810ETMillrock Aviation Financial LLC · Danbury, CTN812RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN813VTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN818LWLeveled Wings LLC · Calabasas, CAN822NPProductivity Strategies LLC · Olathe, KSN826APApi Aviation LLC · New Brighton, MNN827UBcu 2000 LLC · Pleasant Prairie, WIN831DRDriscolls Inc · Watsonville, CAN831MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN833JBImt Holdings Management Co LLC · Sherman Oaks, CAN844UPUnion Pacific Railroad Co · Omaha, NEN845UPUnion Pacific Railroad Co · Omaha, NEN846UPUnion Pacific Railroad Co · Omaha, NEN84PJHampton Airways Inc · Sellersburg, INN850TCRt Falcon Enterprises LLC · Bloomfield Hills, MIN851MJet Plane Management LLC · Saint Paul, MNN855DGDollar General Corp · Goodlettsville, TNN855TJLark Aviation LLC · Reno, NVN857SSSimon Aviation LLC · Birmingham, MIN85HDHomerlease Co Inc · Atlanta, GA
Back to AD 2002-23-19