Skip to content

Registered aircraft · 108

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:2016-20-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-20-13') 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:2016-20-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-20-13')
  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:2016-20-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-20-13')
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.

N137ARWyatt Aerospace LLC · Chandler, AZS/N 362 N230ARWyatt Aerospace LLC · Chandler, AZS/N 230 N271ADBank Of Utah Trustee · Salt Lake City, UTS/N 0271 N272AYAersale Inc · Coral Gables, FLBuilt 2000 · S/N 0333 N280AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 1022 N281AYJetran LLC · Horseshoe Bay, TXBuilt 2009 · S/N 1041 N287AYJetran LLC · Horseshoe Bay, TXBuilt 2013 · S/N 1417 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 N302PFUmb Bank Na Trustee · Salt Lake City, UTS/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 N337QTBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 791 N338QTBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1382 N342AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 1342 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 N370HAHawaiian Airlines Inc · Honolulu, HIBuilt 2014 · S/N 1511 N373HAHawaiian Airlines Inc · Honolulu, HIBuilt 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 N378HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 1615 N379HAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 1672 N380HAAelf Msn 1104 LLC · Chicago, ILBuilt 2010 · S/N 1104 N381HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 1114 N382HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 1171 N383HAHawaiian Airlines Inc · Honolulu, HIBuilt 2011 · S/N 1217 N384HAHawaiian Airlines Inc · Honolulu, HIBuilt 2011 · S/N 1259 N385HAHawaiian Airlines Inc · Honolulu, HIBuilt 2012 · S/N 1295 N386HAAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 1302 N388HAAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 1310 N389HABank Of Utah Trustee · Salt Lake City, UTS/N 1316 N390HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1389 N391HAHawaiian Airlines Inc · Honolulu, HIBuilt 2013 · S/N 1399 N392HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1404 N393HAAlaska Airlines Inc · Seatac, WABuilt 2013 · S/N 1422 N395HAAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 1469 N396HAHawaiian Airlines Inc · Honolulu, HIBuilt 2014 · S/N 1488 N399HAHawaiian Airlines Inc · Honolulu, HIBuilt 2014 · S/N 1496 N455ACBank Of Utah Trustee · Salt Lake City, UTS/N 1364 N4621KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1902 N4649KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1863 N4663KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1865 N4787KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1874

Back to AD 2016-20-13