AD 2012-06-11
Registered aircraft · 411
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:2012-06-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-06-11')
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:2012-06-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-06-11') 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.
N679NKUmb Bank Na Trustee · Salt Lake City, UTN680NKUmb Bank Na Trustee · Salt Lake City, UTN681NKSpirit Airlines LLC · Dania Beach, FLN682NKSpirit Airlines LLC · Dania Beach, FLN683NKSpirit Airlines LLC · Dania Beach, FLN684NKSpirit Airlines LLC · Dania Beach, FLN685NKSpirit Airlines LLC · Dania Beach, FLN686NKSpirit Airlines LLC · Dania Beach, FLN687NKSpirit Airlines LLC · Dania Beach, FLN701FRUmb Bank Na Trustee · Salt Lake City, UTN702FRBank Of Utah Trustee · Salt Lake City, UTN704FRBank Of Utah Trustee · Salt Lake City, UTN705FRBank Of Utah Trustee · Salt Lake City, UTN706FRBank Of Utah Trustee · Salt Lake City, UTN708FRWilmington Trust Co Trustee · Wilmington, DEN709FRWilmington Trust Co Trustee · Wilmington, DEN710FRWilmington Trust Co Trustee · Wilmington, DEN711FRBank Of Utah Trustee · Salt Lake City, UTN712FRWilmington Trust Co Trustee · Wilmington, DEN713FRBank Of Utah Trustee · Salt Lake City, UTN714FRBank Of Utah Trustee · Salt Lake City, UTN715FRWilmington Trust Co Trustee · Wilmington, DEN716FRWells Fargo Trust Co Na Trustee · Salt Lake City, UTN717FRBank Of Utah Trustee · Salt Lake City, UTN718FRUmb Bank Na Trustee · Salt Lake City, UTN719FRWells Fargo Trust Co Na Trustee · Columbia, MDN720FRWilmington Trust Co Trustee · Wilmington, DEN721FRBank Of Utah Trustee · Salt Lake City, UTN722FRAlc A321 8579 LLC · Camden, DEN723FRAlc A321 8640 LLC · Camden, DEN827QDelaware Aircraft Trust LLC Trustee · New Castle, DEN851ASUmb Bank Na Trustee · Salt Lake City, UTN900UWAmerican Airlines Inc · Fort Worth, TXN901AAAmerican Airlines Inc · Fort Worth, TXN902AABank Of Utah Trustee · Salt Lake City, UTN903AAAmerican Airlines Inc · Fort Worth, TXN903JBJetblue Airways Corp · Long Island City, NYN904AABank Of Utah Trustee · Salt Lake City, UTN905AUBank Of Utah Trustee · Salt Lake City, UTN905JBJetblue Airways Corp · Long Island City, NYN906AABank Of Utah Trustee · Salt Lake City, UTN907AABank Of Utah Trustee · Salt Lake City, UTN907JBJetblue Airways Corp · Long Island City, NYN908AABank Of Utah Trustee · Salt Lake City, UTN909AMWilmington Trust Co Trustee · Wilmington, DEN910AUWilmington Trust Co Trustee · Wilmington, DEN912UYAmerican Airlines Inc · Fort Worth, TXN913JBJetblue Airways Corp · Long Island City, NYN913USAmerican Airlines Inc · Fort Worth, TXN914UYAmerican Airlines Inc · Fort Worth, TX
Back to AD 2012-06-11