Skip to content

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

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

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.

N2534UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62645 N261GEBank Of Utah Trustee · Salt Lake City, UTS/N 32790 N2639UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62650 N2644UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63724 N2645UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64989 N27015United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28678 N271ADBank Of Utah Trustee · Salt Lake City, UTS/N 0271 N272AYAersale Inc · Coral Gables, FLBuilt 2000 · S/N 0333 N272JMAlta 777 LLC · Salt Lake City, UTS/N 27652 N2737UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62647 N2747UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64991 N2748UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64994 N2749UUnited Airlines Inc · Chicago, ILBuilt 2019 · S/N 66589 N276JMAlta 777 LLC · Salt Lake City, UTS/N 27636 N280AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 1022 N281AYJetran LLC · Horseshoe Bay, TXBuilt 2009 · S/N 1041 N2846UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64990 N288AYJetran LLC · Horseshoe Bay, TXBuilt 2013 · S/N 1441 N289AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1455 N290AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1480 N291AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 1502 N292AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 1512 N293AYBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2014 · S/N 1526 N29401Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 29401 N294ARJet Midwest Inc · Kansas City, MOS/N 29404 N302PFUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 1574 N3103SSale Reported · Salt Lake City, UTSale reported, pending cancellationS/N 1313 N3300CCsds Asset Management LLC · Marana, AZS/N 211 N330ADBank Of Utah Trustee · Salt Lake City, UTS/N 330 N330QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 1368 N331QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1380 N332QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1428 N334QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1448 N335QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 1534 N336QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 1506 N337QTBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 791 N338QTBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1382 N340YYValiair Lc Trustee · Casper, WYS/N 764 N342AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 1342 N358CLIagcas LLC · Tucson, AZFirst renewal noticeS/N 28358 N360HAAlc A332 1732 LLC · Camden, DEBuilt 2016 · S/N 1732 N361HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 1823 N365JSAelf Msn 242 LLC · Guaynabo, PRS/N 242 N37018United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31680 N370HAHawaiian Airlines Inc · Seattle, WABuilt 2014 · S/N 1511 N373HAHawaiian Airlines Inc · Seattle, WABuilt 2014 · S/N 1530 N374HAAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 1565 N375HAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 1606 N377CLPetrus Iagcas 777 LLC · Dallas, TXS/N 35164 N378HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 1615

Back to AD 2011-07-05