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.
N337PJWilmington Trust Co Trustee · Wilmington, DEN337QTBank Of Utah Trustee · Salt Lake City, UTN338DNUmb Bank Na Trustee · Salt Lake City, UTN338NWDelta Air Lines Inc · Atlanta, GAN338PKWilmington Trust Co Trustee · Wilmington, DEN338QTBank Of Utah Trustee · Salt Lake City, UTN339DNUmb Bank Na Trustee · Salt Lake City, UTN339NWDelta Air Lines Inc · Atlanta, GAN339PLWilmington Trust Co Trustee · Wilmington, DEN340DNUmb Bank Na Trustee · Salt Lake City, UTN340NWDelta Air Lines Inc · Atlanta, GAN340YYValiair Lc Trustee · Casper, WYN341DNUmb Bank Na Trustee · Salt Lake City, UTN341NWDelta Air Lines Inc · Atlanta, GAN34222United Airlines Inc · Chicago, ILN34282Umb Bank Na Trustee · Salt Lake City, UTN342AVUmb Bank Na Trustee · Salt Lake City, UTN342DNUmb Bank Na Trustee · Salt Lake City, UTN342NWDelta Air Lines Inc · Atlanta, GAN342PMWilmington Trust Co Trustee · Wilmington, DEN343DNBank Of Utah Trustee · Salt Lake City, UTN343NWDelta Air Lines Inc · Atlanta, GAN343PNWilmington Trust Co Trustee · Wilmington, DEN344CMCargo Aircraft Management Inc · Wilmington, OHN344DNBank Of Utah Trustee · Salt Lake City, UTN344KDAtares Funding LLC · Miami Beach, FLN344NWDelta Air Lines Inc · Atlanta, GAN344PPWilmington Trust Co Trustee · Wilmington, DEN345AVAircol 20 · Wilmington, DEN345DNBank Of Utah Trustee · Salt Lake City, UTN345NWDelta Air Lines Inc · Atlanta, GAN346DNBank Of Utah Trustee · Salt Lake City, UTN346PRWilmington Trust Co Trustee · Wilmington, DEN347AZCargo Aircraft Management Inc · Wilmington, OHN347CMCargo Aircraft Management Inc · Wilmington, OHN347DNBank Of Utah Trustee · Salt Lake City, UTN347NWDelta Air Lines Inc · Atlanta, GAN348DNBank Of Utah Trustee · Salt Lake City, UTN348NWDelta Air Lines Inc · Atlanta, GAN349CMCargo Aircraft Management Inc · Wilmington, OHN349DXBank Of Utah Trustee · Salt Lake City, UTN349NWDelta Air Lines Inc · Atlanta, GAN350DNBank Of Utah Trustee · Salt Lake City, UTN350NADelta Air Lines Inc · Atlanta, GAN3518JJetran LLC · Horseshoe Bay, TXN351CMCargo Aircraft Management Inc · Wilmington, OHN351DNBank Of Utah Trustee · Salt Lake City, UTN351NWDelta Air Lines Inc · Atlanta, GAN35204United Airlines Inc · Chicago, ILN35236United Airlines Inc · Chicago, IL
Back to AD 2007-19-13