AD 2011-12-01
Registered aircraft · 4,702
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:2011-12-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-12-01')
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:2011-12-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-12-01') 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.
N111REX Aviation Group LLC · Beverly Hills, CAN111USAmerican Airlines Inc · Fort Worth, TXN111ZMAmerican Airlines Inc · Fort Worth, TXN11206United Airlines Inc · Chicago, ILN112ANAmerican Airlines Inc · Fort Worth, TXN112DNDelta Air Lines Inc · Atlanta, GAN112PSFrontera Flight Holdings Inc · Dover, DEN112USAmerican Airlines Inc · Fort Worth, TXN113ANAmerican Airlines Inc · Fort Worth, TXN113DXDelta Air Lines Inc · Atlanta, GAN114DNDelta Air Lines Inc · Atlanta, GAN114UWAmerican Airlines Inc · Fort Worth, TXN115DNDelta Air Lines Inc · Atlanta, GAN115NABasler Turbo Conversions LLC · Oshkosh, WIN115NNAmerican Airlines Inc · Fort Worth, TXN115PKJet Midwest Inc · Kansas City, MON115SABasler Turbo Conversions LLC · Oshkosh, WIN116ANUmb Bank Na Trustee · Salt Lake City, UTN116DNDelta Air Lines Inc · Atlanta, GAN116SEEberhardt Marilyn Trustee · Danville, CAN117ANAmerican Airlines Inc · Fort Worth, TXN117DXDelta Air Lines Inc · Atlanta, GAN117UWBank Of Utah Trustee · Salt Lake City, UTN118DYDelta Air Lines Inc · Atlanta, GAN118NNUmb Bank Na Trustee · Salt Lake City, UTN118USBank Of Utah Trustee · Salt Lake City, UTN119DNDelta Air Lines Inc · Atlanta, GAN119FEFederal Express Corp · Memphis, TNN119NAUnited States Government · Washington, DCN119NNUmb Bank Na Trustee · Salt Lake City, UTN119USBank Of Utah Trustee · Salt Lake City, UTN1200KDelta Air Lines Inc · Atlanta, GAN1201PDelta Air Lines Inc · Atlanta, GAN12028American Airlines Inc · Fort Worth, TXN120DNDelta Air Lines Inc · Atlanta, GAN120EEUmb Bank Na Trustee · Salt Lake City, UTN120JMSouth Aircraft Leasing Inc · Wilmington, DEN120UAUnited Airlines Inc · Chicago, ILN120UPUnited Parcel Service Co · Louisville, KYN12109United Airlines Inc · Chicago, ILN12114United Airlines Inc · Chicago, ILN12116United Airlines Inc · Chicago, ILN12125United Airlines Inc · Chicago, ILN1217AAndromeda Leasing I LLC · Purchase, NYN121ANBank Of Utah Trustee · Salt Lake City, UTN121DZDelta Air Lines Inc · Atlanta, GAN121UPUnited Parcel Service Co · Louisville, KYN121UWBank Of Utah Trustee · Salt Lake City, UTN12216United Airlines Inc · Chicago, ILN12218United Airlines Inc · Chicago, IL
Back to AD 2011-12-01