AD 2017-23-06
Registered aircraft · 1,090
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-23-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-23-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-23-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-23-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.
N435SARi Cl600 LLC · Beverly, MAN436AWAir Wisconsin Airlines LLC · Appleton, WIN436DMShooter And Butts Aviation LLC · Sheridan, WYN438AWCsi Aviation Inc · Killeen, TXN438SWCorporate Flight Management Inc DBA · Smyrna, TNN439AWCsi Aviation Inc · Killeen, TXN439SWBank Of Utah Trustee · Salt Lake City, UTN440AWAir Wisconsin Airlines LLC · Appleton, WIN440SWSkywest Airlines Inc · Saint George, UTN441SWSkywest Airlines Inc · St George, UTN441ZWUmb Bank Na Trustee · Salt Lake City, UTN442AWAir Wisconsin Airlines LLC · Appleton, WIN442SWSkywest Airlines Inc · St George, UTN443AWAir Wisconsin Airlines LLC · Appleton, WIN444CZPelo Aviation LLC · Miami, FLN444ZWUmb Bank Na Trustee · Salt Lake City, UTN445AWAir Wisconsin Airlines LLC · Appleton, WIN445SWSkywest Airlines Inc · Saint George, UTN446AWAir Wisconsin Airlines LLC · Appleton, WIN446SWSkywest Airlines Inc · Saint George, UTN447AWAir Wisconsin Airlines LLC · Appleton, WIN447SWSkywest Airlines Inc · St George, UTN448AWAir Wisconsin Airlines LLC · Appleton, WIN448SWSkywest Airlines Inc · St George, UTN449AWAir Wisconsin Airlines LLC · Appleton, WIN449SWSkywest Airlines Inc · St George, UTN44UAShiloh International Inc · Orland Park, ILN450AWAir Wisconsin Airlines LLC · Appleton, WIN451AWAir Wisconsin Airlines LLC · Appleton, WIN452AWSpire Aviation II LLC · Mooresville, NCN452SWSkywest Airlines Inc · St George, UTN453AWAir Wisconsin Airlines LLC · Appleton, WIN453GLDelaware Aircraft Trust LLC Trustee · New Castle, DEN453SWSkywest Airlines Inc · St George, UTN454AWAir Wisconsin Airlines LLC · Appleton, WIN454SWSkywest Airlines Inc · St George, UTN455AWCsi Aviation Inc · Killeen, TXN455CALogos Aviation Inc · Fort Lauderdale, FLN455SWSkywest Airlines Inc · St George, UTN456ZWRi Voyager LLC · Beverly, MAN457AWUmb Bank Na Trustee · Salt Lake City, UTN457SWSkywest Airlines Inc · St George, UTN458AWUmb Bank Na Trustee · Salt Lake City, UTN459AWUmb Bank Na Trustee · Salt Lake City, UTN459SWSkywest Airlines Inc · Saint George, UTN460AWCsi Aviation Inc · Killeen, TXN460SWSkywest Airlines Inc · Saint George, UTN461SWSkywest Airlines Inc · St George, UTN462AWAir Wisconsin Airlines LLC · Appleton, WIN463AWUmb Bank Na Trustee · Salt Lake City, UT
Back to AD 2017-23-06