Skip to content

Registered aircraft · 501

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:2012-08-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:2012-08-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:2012-08-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:2012-08-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:2012-08-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:2012-08-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.

N249LRSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 15275 N272PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15272 N279PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15279 N292PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15292 N293PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15293 N294PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15294 N295PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15295 N296PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15296 N297PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15297 N298PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15298 N299PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15299 N300PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15300 N301PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15301 N302PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15302 N303PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15303 N304PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15304 N305PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15305 N306PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15306 N307PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15307 N308PQDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2014 · S/N 15308 N309PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15309 N310PQDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2014 · S/N 15310 N311PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15311 N313PQDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2014 · S/N 15313 N314PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15314 N315PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15315 N316PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15316 N317CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10055 N319PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15319 N320PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15320 N324PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15324 N325PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15325 N326MSSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15124 N326PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15326 N329MSSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15126 N329PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15329 N330PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15330 N331CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10061 N331PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15331 N335PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15335 N336PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15336 N337PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15337 N340CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10062 N341PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15341 N348PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 15348 N349PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 15349 N354CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10064 N355CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10067 N367CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10069 N368CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10075

Back to AD 2012-08-05