Skip to content

AD 2005-13-02 R1

Registered aircraft · 493

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

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, GABuilt 2014 · S/N 15308 N309PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15309 N310PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15310 N311PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15311 N313PQDelta Air Lines Inc · Atlanta, GABuilt 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 N371CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10082 N376CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10092 N379CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10102 N390CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10106 N391CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10108 N398CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10112 N478PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 15478 N479PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 15479 N480PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 15480 N482PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 15482

Back to AD 2005-13-02 R1