AD 2018-20-13
Registered aircraft · 2,770
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:2018-20-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-20-13')
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:2018-20-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-20-13') 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.
N540USDelta Air Lines Inc · Atlanta, GAN541USDelta Air Lines Inc · Atlanta, GAN54241United Airlines Inc · Chicago, ILN542LAQuetro Aircraft Leasing Trust · Wilmington, DEN542USDelta Air Lines Inc · Atlanta, GAN543USDelta Air Lines Inc · Atlanta, GAN544USDelta Air Lines Inc · Atlanta, GAN545USDelta Air Lines Inc · Atlanta, GAN546ASAlaska Airlines Inc · Seattle, WAN54711United Airlines Inc · Chicago, ILN547USDelta Air Lines Inc · Atlanta, GAN548ASAlaska Airlines Inc · Seattle, WAN548USDelta Air Lines Inc · Atlanta, GAN549USDelta Air Lines Inc · Atlanta, GAN550NWDelta Air Lines Inc · Atlanta, GAN551ASAlaska Airlines Inc · Seattle, WAN551NWDelta Air Lines Inc · Atlanta, GAN552ASAlaska Airlines Inc · Seattle, WAN552NWDelta Air Lines Inc · Atlanta, GAN553ASAlaska Airlines Inc · Seattle, WAN553NWDelta Air Lines Inc · Atlanta, GAN554NWDelta Air Lines Inc · Atlanta, GAN555NWDelta Air Lines Inc · Atlanta, GAN556ASAlaska Airlines Inc · Seattle, WAN556NWDelta Air Lines Inc · Atlanta, GAN557ASAlaska Airlines Inc · Seattle, WAN557NWDelta Air Lines Inc · Atlanta, GAN558ASAlaska Airlines Inc · Seattle, WAN559ASAlaska Airlines Inc · Seattle, WAN560ASAlaska Airlines Inc · Seatac, WAN562ASBank Of Utah Trustee · Salt Lake City, UTN562BJRegistration Pending · North Salt Lake, UTRegistration pendingN563ASAlaska Airlines Inc · Seatac, WAN563WNWilmington Trust Co Trustee · Wilmington, DEN564ASBank Of Utah Trustee · Salt Lake City, UTN564LATagua Owner Trust · Wilmington, DEN565ASAlaska Airlines Inc · Seattle, WAN566ASAlaska Airlines Inc · Seattle, WAN566LAJilguero Owner Trust · Wilmington, DEN567CACascade Spares Inc · Knoxville, TNN56859United Airlines Inc · Chicago, ILN568ASAlaska Airlines Inc · Seattle, WAN568LATagua Owner Trust · Wilmington, DEN569AMUmb Bank Na Trustee · Salt Lake City, UTN569ASAlaska Airlines Inc · Seatac, WAN569AZAmazon.Com Services LLC · Seattle, WAN570ASAlaska Airlines Inc · Seattle, WAN570LATagua Owner Trust · Wilmington, DEN57111United Airlines Inc · Chicago, ILN571ASUmb Bank Na Trustee · Salt Lake City, UT
Back to AD 2018-20-13