AD 2011-07-05
Registered aircraft · 351
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-07-05')
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-07-05')
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-07-05') 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-07-05') 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.
N379HAWells Fargo Trust Co Na Trustee · Columbia, MDN380HAAelf Msn 1104 LLC · Chicago, ILN381HAUmb Bank Na Trustee · Salt Lake City, UTN382HAUmb Bank Na Trustee · Salt Lake City, UTN383HAHawaiian Airlines Inc · Seattle, WAN384HAHawaiian Airlines Inc · Seattle, WAN385HAHawaiian Airlines Inc · Seattle, WAN386HAAlaska Airlines Inc · Seatac, WAN388HAAlaska Airlines Inc · Seattle, WAN389HABank Of Utah Trustee · Salt Lake City, UTN390HAWilmington Trust Co Trustee · Wilmington, DEN391HAHawaiian Airlines Inc · Seatac, WAN392HAWilmington Trust Co Trustee · Wilmington, DEN393HAAlaska Airlines Inc · Seatac, WAN395HAAlaska Airlines Inc · Seattle, WAN396HAHawaiian Airlines Inc · Seattle, WAN399HAHawaiian Airlines Inc · Seattle, WAN399MTBank Of Utah Trustee · Salt Lake City, UTN455ACBank Of Utah Trustee · Salt Lake City, UTN4621KUmb Bank Na Trustee · Salt Lake City, UTN463ACUmb Bank Na Trustee · Salt Lake City, UTN4649KUmb Bank Na Trustee · Salt Lake City, UTN4663KUmb Bank Na Trustee · Salt Lake City, UTN4787KUmb Bank Na Trustee · Seatac, WAN508BCAlta 777 LLC · Salt Lake City, UTN509BCJet Midwest Inc · Kansas City, MON519BCAlta 777 LLC · Salt Lake City, UTN529CGCargo Aircraft Management Inc · Wilmington, OHN57016United Airlines Inc · Chicago, ILN577NANasa Langley Research Center · Hampton, VAN577TABank Of Utah Trustee · Salt Lake City, UTN5827KUmb Bank Na Trustee · Seatac, WAN5843KUmb Bank Na Trustee · Salt Lake City, UTN5869KUmb Bank Na Trustee · Salt Lake City, UTN5879KUmb Bank Na Trustee · Salt Lake City, UTN5881KUmb Bank Na Owner Trustee · Salt Lake City, UTN5897KUmb Bank Na Trustee · Salt Lake City, UTN60VLBank Of Utah Trustee · Salt Lake City, UTN666CATvpx Trust Co LLC Trustee · North Salt Lake, UTN69020United Airlines Inc · Chicago, ILN7019KAmazon.Com Services LLC · Seattle, WAN7057KAmazon.Com Services LLC · Seattle, WAN705DNJetran LLC · Horseshoe Bay, TXN709DNBank Of Utah Trustee · Salt Lake City, UTN70VLBank Of Utah Trustee · Salt Lake City, UTN710DNJetran LLC · Horseshoe Bay, TXN717ANAmerican Airlines Inc · Fort Worth, TXN718ANAmerican Airlines Inc · Fort Worth, TXN719ANAmerican Airlines Inc · Fort Worth, TXN720ANBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2011-07-05