AD 2007-19-13
Registered aircraft · 2,446
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:2007-19-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:2007-19-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:2007-19-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:2007-19-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.
N811NWDelta Air Lines Inc · Atlanta, GAN812NNWilmington Trust Co Trustee · Wilmington, DEN812NWDelta Air Lines Inc · Atlanta, GAN813KWAlta 777 LLC · Salt Lake City, UTN813NNWilmington Trust Co Trustee · Wilmington, DEN813NWDelta Air Lines Inc · Atlanta, GAN813VLUmb Bank Na Trustee · Salt Lake City, UTN814KWAlta 777 LLC · Salt Lake City, UTN814NNAmerican Airlines Inc · Fort Worth, TXN814NWDelta Air Lines Inc · Atlanta, GAN815KWAlta 777 LLC · Salt Lake City, UTN815NNWilmington Trust Co Trustee · Wilmington, DEN815NWDelta Air Lines Inc · Atlanta, GAN816NNWilmington Trust Co Trustee · Wilmington, DEN816NWDelta Air Lines Inc · Atlanta, GAN817CMCargo Aircraft Management Inc · Wilmington, OHN817KWAlta 777 LLC · Salt Lake City, UTN817NNAmerican Airlines Inc · Fort Worth, TXN817NWDelta Air Lines Inc · Atlanta, GAN818NNWilmington Trust Co Trustee · Wilmington, DEN818NWDelta Air Lines Inc · Atlanta, GAN819KWAlta 777 LLC · Salt Lake City, UTN819NNAmerican Airlines Inc · Fort Worth, TXN819NWDelta Air Lines Inc · Atlanta, GAN820KWAlta 777 LLC · Salt Lake City, UTN820NNAmerican Airlines Inc · Fort Worth, TXN820NWDelta Air Lines Inc · Atlanta, GAN821AVAircol 22 · Wilmington, DEN821CMCargo Aircraft Management Inc · Wilmington, OHN821JBJetblue Airways Corp · Long Island City, NYN821NNWilmington Trust Co Trustee · Wilmington, DEN821NWDelta Air Lines Inc · Atlanta, GAN822KWAlta 777 LLC · Salt Lake City, UTN822NNWilmington Trust Co Trustee · Wilmington, DEN822NWDelta Air Lines Inc · Atlanta, GAN823NNWilmington Trust Co Trustee · Wilmington, DEN823NWDelta Air Lines Inc · Atlanta, GAN823SYSun Country Inc · Minneapolis, MNN824NNWilmington Trust Co Trustee · Wilmington, DEN824NWDelta Air Lines Inc · Atlanta, GAN824SYSun Country Inc · Minneapolis, MNN825AMWells Fargo Trust Co Na Trustee · Columbia, MDN825KWEal Asset Holdings LLC · Kansas City, MON825NNAmerican Airlines Inc · Fort Worth, TXN825NWDelta Air Lines Inc · Atlanta, GAN826KWAlta 777 LLC · Salt Lake City, UTN826NNAmerican Airlines Inc · Fort Worth, TXN826NWDelta Air Lines Inc · Atlanta, GAN827JBJetblue Airways Corp · Long Island City, NYN827KWAlta 777 LLC · Salt Lake City, UT
Back to AD 2007-19-13