AD 2017-04-01
Registered aircraft · 377
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-04-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-04-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-04-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-04-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.
N2000STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN200AExxon Mobil Corp · Houston, TXN201ACWilmington Trust Co Trustee · Providence, RIN201CETvpx Ars Inc Trustee · North Salt Lake, UTN2030PRegistered aircraftN20CPRegistered aircraftN20RCBristol Air LLC · Missoula, MTN212DDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN221DGDavid Geffen Co · Los Angeles, CAN228ZDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN22TRegistered aircraftN232GBank Of Utah Trustee · Salt Lake City, UTN232KN232k LLC · Midland, TXN235BHHamilton Aviation Inc · Portland, ORN236MJMj Air LLC · Washington, DCN23DCRegistered aircraftN241CETvpx Ars Inc Trustee · North Salt Lake, UTN2425JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN244DSDs Aviation LLC · Indianapolis, INN2461KSix Fifty Holdings LLC · Uniondale, NYN265ECFam LLC · Bell, CAN267BWNamaya Inc · Latrobe, PAN2702Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN270LEDtaa LLC · Dallas, TXN282SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN28UDBank Of Utah Trustee · Salt Lake City, UTN298ALBank Of Utah Trustee · Salt Lake City, UTN298WFrc Holding Inc V · Dover, DEN2CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2LFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2NBank Of Utah Trustee · Salt Lake City, UTN2PGProcter & Gamble Leasing LLC · Cincinnati, OHN302TRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN303HMOdyssey Adventures LLC · Centennial, CON305KNRegistered aircraftN309TTT-Bird Aviation LLC · West Chicago, ILN311WMRegistered aircraftN312ATBank Of Utah Trustee · Salt Lake City, UTN312DSDs V Aviation LLC · Beaverton, ORN313AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN313RGRenair 650 LLC · New York, NYN317LLJrk Property Holdings Inc · Los Angeles, CAN318JSBank Of Utah Trustee · Salt Lake City, UTN318LSRegistered aircraftN319PEPlus3 Aviation LLC · West Hollywood, CAN3251KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN325APTalaria Logistics LLC · Denver, CON329SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN331ABAircraft Trust & Financing Corp Trustee · Wilmington, DEN333GWBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2017-04-01