AD 2011-21-08
Registered aircraft · 5,377
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-21-08')
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-21-08')
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-21-08') 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-21-08') 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.
N111RZMetropolitan Telecommunications Corp Of De LLC · Holmdel, NJN111USAmerican 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, TXN112VLBank Of Utah Trustee · Salt Lake City, UTN113ANAmerican Airlines Inc · Fort Worth, TXN113DXDelta Air Lines Inc · Atlanta, GAN113SRAdams Aviation Services Inc Trustee · Wilmington, DEN114DNDelta Air Lines Inc · Atlanta, GAN114UWAmerican Airlines Inc · Fort Worth, TXN115DNDelta Air Lines Inc · Atlanta, GAN115NNAmerican Airlines Inc · Fort Worth, TXN116ANUmb Bank Na Trustee · Salt Lake City, UTN116DNDelta Air Lines Inc · Atlanta, GAN116HLWorld Tech Aviation LLC · Valencia, CAN117AACorsair Two LLC · Hillsboro, ORN117ANAmerican Airlines Inc · Fort Worth, TXN117DXDelta Air Lines Inc · Atlanta, GAN117UWBank Of Utah Trustee · Salt Lake City, UTN118DYDelta Air Lines Inc · Atlanta, GAN118MTOne World Aviation 118 LLC · 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, UTN120UAUnited 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-21-08