Skip to content

Registered aircraft · 1,131

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-22-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-22-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-22-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-22-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-22-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-22-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.

N816DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31927 N816NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31081 N817DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31929 N817NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29558 N818DADelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31928 N818NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30910 N819DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31930 N819NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31083 N820DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31931 N820NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29559 N821DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31932 N821NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30912 N822DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31933 N822NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31085 N823DNDelta Airlines Inc · Atlanta, GABuilt 2014 · S/N 31934 N823NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29560 N823SYSun Country Inc · Minneapolis, MNS/N 33971 N824DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31935 N824NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30916 N824SYSun Country Inc · Minneapolis, MNBuilt 2005 · S/N 33976 N825AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36699 N825DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31936 N825NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31087 N826DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31937 N826NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31089 N827DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31938 N827NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33209 N828DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31939 N829DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31941 N829NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33210 N830DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31940 N830NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31091 N831DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31942 N831NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33211 N832DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31943 N832NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33521 N833DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31944 N833NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31093 N834DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31946 N834NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 29576 N835DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31945 N835NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 29577 N836DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31947 N836NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31095 N837DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31948 N837NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30908 N838DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31949 N838NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31097 N839DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31950 N839NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29557

Back to AD 2016-22-13