AD 2017-17-18
Registered aircraft · 1,791
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-17-18')
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-17-18')
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-17-18') 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-17-18') 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.
N125SYSky West Airlines Inc · St George, UTN126HQRepublic Airways Inc · Carmel, INN127HQRepublic Airways Inc · Carmel, INN127SYSkywest Airlines Inc · St George, UTN128SYSkywest Airlines Inc · St George, UTN129HQRepublic Airways Inc · Carmel, INN130HQRepublic Airways Inc · Carmel, INN130SYSkywest Airlines Inc · Saint George, UTN131EVDelta Air Lines Inc · Atlanta, GAN131HQRepublic Airways Inc · Carmel, INN131SYSkywest Airlines Inc · St George, UTN132EVDelta Air Lines Inc · Atlanta, GAN132HQRepublic Airways Inc · Carmel, INN132SYSkywest Airlines Inc · St George, UTN133EVDelta Air Lines Inc · Atlanta, GAN133HQRepublic Airways Inc · Carmel, INN133SYSkywest Airlines Inc · St George, UTN134EVDelta Air Lines Inc · Atlanta, GAN134HQRepublic Airways Inc · Carmel, INN134SYSkywest Airlines Inc · St George, UTN134WM560 Company Inc · Anchorage, AKN135EVDelta Air Lines Inc · Atlanta, GAN135HQRepublic Airways Inc · Carmel, INN135SMStonegate Leasing 2020 LLC · Natick, MAN135SYSkywest Airlines Inc · St George, UTN136EVDelta Air Lines Inc · Atlanta, GAN136HQRepublic Airways Inc · Carmel, INN136SYSkywest Airlines Inc · St George, UTN137EVDelta Air Lines Inc · Atlanta, GAN137HQRepublic Airways Inc · Carmel, INN138EVDelta Air Lines Inc · Atlanta, GAN138HQRepublic Airways Inc · Carmel, INN138SYSkywest Airlines Inc · St George, UTN139LJGlobal Aircraft Trust Inc Trustee · Cheyenne, WYN139SYSkywest Airlines Inc · St George, UTN140SYSkywest Airlines Inc · Saint George, UTN141SHLead And Steel 4 LLC · Fountain Valley, CAN141SYSkywest Airlines Inc · Saint George, UTN142SYSkywest Airlines Inc · St George, UTN143SYSkywest Airlines Inc · St George, UTN144MHW Hughes Aviation LLC · Stanton, TXN144SYSkywest Airlines Inc · St George, UTN145SYSkywest Airlines Inc · St George, UTN146PQDelta Air Lines Inc · Atlanta, GAN146SYSkywest Airlines Inc · St George, UTN147PQDelta Air Lines Inc · Atlanta, GAN148SYSkywest Airlines Inc · St George, UTN149SYSkywest Airlines Inc · St George, UTN150BBMs Hawker LLC · Farmington Hills, MIN150SYSkywest Airlines Inc · St George, UT
Back to AD 2017-17-18