AD 2017-20-01
Registered aircraft · 341
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:2017-20-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-20-01')
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:2017-20-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-20-01') 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.
N75MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN75XPRedd Air LLC · Vancouver, WAN763PPTop Air Texas LLC · Glendale, CAN766RARoyal Air Freight Inc · Waterford, MIN76CKKalitta Charters LLC · Ypsilanti, MIN770CCTaughannock Aviation Corp · Ithaca, NYN777QLMed Air LLC · Lawrenceville, GAN791CPMaxus Capital Group LLC · Cleveland, OHN793RCLfg Aviation Holdings LLC · Kalispell, MTN799RMBank Of Utah Trustee · Salt Lake City, UTN799SN143bl LLC · Hixson, TNN800ABCheck Clearing House Aviation LLC · Glenwood Springs, CON800LQAdc Aviation LLC · Birmingham, ALN800NJGlobal Empire Trust LLC · Fort Lauderdale, FLN800PEFour C Air Inc · Delano, CAN800THHoover Aviation LLC · Nashville, TNN800UKJ W Construction Co Inc · Wise, VAN800WWPnw Transport LLC · Tucson, AZN804BHMahaska Bottling Co · Oskaloosa, IAN804MC824 Holdco LLC · Salt Lake City, UTN806GJPb Air LLC · Higley, AZN806MNJm Soar LLC · Paradise Valley, AZN808MCLrt Aero Partners LLC · Sheridan, WYN812LLH800 Vi LLC · Stuart, FLN812SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN816KYBcp Fa Ap LLC · Providence, RIN817SDSea Aviation Holdings LLC · Wilmington, DEN818LXN818lx LLC · Wilmington, DEN819EXPreserve Air LLC · Honolulu, HIN822RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN823AMAirmed International LLC · Birmingham, ALN823HLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN825QTKjm Air LLC · Aurora, ILN825WKMadunn El LLC · Wayzata, MNN826CALear Management LLC · Tulsa, OKN831LXM&N Equipment LLC · Englewood, CON831PC505sj LLC · Jackson, TNN835MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN849EAIq Worldwide Solutions LLC · Tampa, FLN84UPN84up LLC · Wilmington, DEN850ENBcbg Capital LLC · Clearwater, FLN855MWMunguia Mario · Downey, CAN85PTWestwind Air LLC · Oklahoma City, OKN864BFPsx LLC · Sheridan, WYN865CSReef Aviation LLC · Knoxville, TNN867TXAirplane 1 LLC · Richmond, TXN870ZPotomac Corp · Wheeling, ILN876MRBudget Jet LLC · Greenville, DEN8778Ligon Air LLC · Birmingham, ALN878MBMb Air LLC · New York, NY
Back to AD 2017-20-01