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.
N87KBKkb Holdings LLC · Wilmington, DEN880CHEcho Acquisitions LLC · Dover, DEN887SGN45ax LLC · Tulsa, OKN889CAGracon Express LLC · Lafayette, CON890LTLife Time Inc · Chanhassen, MNN892TXByte Me Transportation Inc · Fort Pierce, FLN89TBAir Med Capital LLC · Kissimmee, FLN900DTega Air LLC · Bend, ORN900KUFalcon 900-91 LLC · Lewes, DEN900NHNew Mfis Holdings LLC · Henderson, NVN900RLEib Equipment Leasing LLC · Naples, FLN900YPVillages Equipment Co · Leesburg, FLN903TBTres Borrachos LLC · Scottsdale, AZN904YPVillages Equipment Co · Leesburg, FLN908SBFalcon Hunter LLC · Houston, TXN90FBRegistered aircraftN90WPRegistered aircraftN915APAir Services Corp · Wilmington, DEN917SMAircraft Fidelity Corporation Trustee · Dover, DEN919WTAir Waukegan LLC · Waukegan, ILN920EJAlliance Aviation Group LLC · Wilmington, DEN922TG100 LLC · Rancho Santa Fe, CAN927BRFur Management & Consulting LLC · Junction, TXN929TCypress Investments LLC · Cheyenne, WYN931CAWild Aviation LLC · Rockford, ILN942FKForty Er LLC · Bethany, OKN950JBKlc 158 LLC · Dallas, TXN955VGTvpx Aircraft Solutions Trustee · North Salt Lake, UTN979JCTamara LLC · Dover, DEN981CLHawker N981ce & N987ce LLC · Wilmington, DEN984BXFarm Leasing F Inc · Atlanta, INN985CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN987CFPeekey Lumbus LLC · Vista, CAN987CLHawker N981ce & N987ce LLC · Wilmington, DEN988AKExecutive Aircraft Sales LLC · Charlotte, NCN988RCMoyle Petroleum Co · Rapid City, SDN988RSWorldwide Option LLC · Lewes, DEN991FRAudaciter LLC · Fort Lauderdale, FLN994EAE D Santos & Associates LLC Trustee · Wilmington, DEN999MKBig Hole Aviation LLC · Helena, MTN9RARoyal Air Freight Inc · Waterford, MI
Back to AD 2017-20-01