AD 2003-14-01
Registered aircraft · 231
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:2003-14-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:2003-14-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:2003-14-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:2003-14-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.
N172UPUnited Parcel Service Co · Louisville, KYN173UPUnited Parcel Service Co · Louisville, KYN174UPUnited Parcel Service Co · Louisville, KYN230ARWyatt Aerospace LLC · Chandler, AZN271ADBank Of Utah Trustee · Salt Lake City, UTN272AYAersale Inc · Coral Gables, FLN280AYBank Of Utah Trustee · Salt Lake City, UTN281AYJetran LLC · Horseshoe Bay, TXN288AYJetran LLC · Horseshoe Bay, TXN289AYBank Of Utah Trustee · Salt Lake City, UTN290AYBank Of Utah Trustee · Salt Lake City, UTN291AYBank Of Utah Trustee · Salt Lake City, UTN292AYBank Of Utah Trustee · Salt Lake City, UTN293AYBank Of Utah Owner Trustee · Salt Lake City, UTN302PFUmb Bank Na Trustee · Salt Lake City, UTN3103SSale Reported · Salt Lake City, UTSale reported, pending cancellationN3300CCsds Asset Management LLC · Marana, AZN330ADBank Of Utah Trustee · Salt Lake City, UTN337QTBank Of Utah Trustee · Salt Lake City, UTN338QTBank Of Utah Trustee · Salt Lake City, UTN342AVUmb Bank Na Trustee · Salt Lake City, UTN360HAAlc A332 1732 LLC · Camden, DEN361HAWilmington Trust Co Trustee · Wilmington, DEN365JSAelf Msn 242 LLC · Guaynabo, PRN370HAHawaiian Airlines Inc · Seattle, WAN373HAHawaiian Airlines Inc · Seattle, WAN374HAAlaska Airlines Inc · Seattle, WAN375HAWells Fargo Trust Co Na Trustee · Columbia, MDN378HAUmb Bank Na Trustee · Salt Lake City, UTN379HAWells 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, WAN430FEFederal Express Corp · Memphis, TNN431FEFederal Express Corp · Memphis, TNN453FEFederal Express Corp · Memphis, TNN454FEFederal Express Corp · Memphis, TN
Back to AD 2003-14-01