AD 2017-20-06
Registered aircraft · 364
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-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:2017-20-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:2017-20-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:2017-20-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.
N534XJTvpx Aircraft Solutions Inctrustee · North Salt Lake, UTN535FXFlexjet LLC · Cleveland, OHN535XJU S Bank Na · Marshall, MNN536FXFlexjet LLC · Cleveland, OHN536XJBank Of Utah Trustee · Salt Lake City, UTN537XJBank Of Utah Trustee · Salt Lake City, UTN538FXFlexjet LLC · Cleveland, OHN538XJBank Of Utah Trustee · Salt Lake City, UTN539XJBank Of Utah Trustee · Salt Lake City, UTN540FXFlexjet LLC · Cleveland, OHN541FXCitation X Parts LLC · Liberty, NCN541XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN542FXCitation X Parts LLC · Liberty, NCN545XJBank Of Utah Trustee · Salt Lake City, UTN546XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN547FXFlexjet LLC · Cleveland, OHN547XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN548XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN549FXCitation X Parts LLC · Liberty, NCN549XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN54HAL&D Air LLC · Minneapolis, MNN550FXFlexjet LLC · Cleveland, OHN550XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN551FXFlexjet LLC · Cleveland, OHN551XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN552FXCitation X Parts LLC · Liberty, NCN552XJBank Of Utah Trustee · Salt Lake City, UTN553FXCitation X Parts LLC · Liberty, NCN556DDDelta Aviation LLC · West Bend, WIN556FXFlexjet LLC · Cleveland, OHN557XJBank Of Utah Trustee · Salt Lake City, UTN55EBBank Of Utah Trustee · Salt Lake City, UTN56BACore Natural Resources Inc · Canonsburg, PAN575FDEcho Acquisitions LLC · Dover, DEN578XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN585AXCentury Mold Holdings LLC · Rochester, NYN58HAAcrisure Aircraft N58ha LLC · New York, NYN58LCAtlantic Excel LLC · San Marcos, CAN590MCRegistered aircraftN595CBTvpx Ars Inc Trustee · North Salt Lake, UTN59KGRegistered aircraftN5LAir Sansone LLC · Wilmington, DEN600CFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN606RPSydes Aviation LLC · Jacksonville, NCN607GJGabinoah LLC · Miami Beach, FLN608KHIronwood Sky Holdings LLC · Wilmington, DEN608RPWheels Up Partners LLC · New York, NYN610CGMac Air LLC · Sellersburg, INN610HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN615WDCharlie 300 LLC · Columbus, OH
Back to AD 2017-20-06