Skip to content

AD 2009-18-19 R1

Registered aircraft · 107

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:2009-18-19-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:2009-18-19-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:2009-18-19-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:2009-18-19-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:2009-18-19-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:2009-18-19-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.

N577TABank Of Utah Trustee · Salt Lake City, UTS/N 355 N5827KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 1081 N5843KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 1071 N5869KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1205 N5879KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1226 N5881KUmb Bank Na Owner Trustee · Salt Lake City, UTBuilt 2010 · S/N 1167 N5897KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1245 N7019KAmazon.Com Services LLC · Seattle, WAS/N 1359 N7057KAmazon.Com Services LLC · Seattle, WAS/N 1546 N801NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0524 N802NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0533 N803NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0542 N804NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0549 N805NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0552 N806NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0578 N807NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0588 N808NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0591 N809NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0663 N810NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0674 N811NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0690 N812NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0784 N813NWDelta Air Lines Inc · Atlanta, GAS/N 0799 N814NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0806 N815NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0817 N816NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0827 N817CMCargo Aircraft Management Inc · Wilmington, OHS/N 1269 N817NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0843 N818NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0857 N819NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0858 N820NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0859 N821CMCargo Aircraft Management Inc · Wilmington, OHS/N 1146 N821NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0865 N822NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1627 N823NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1628 N824NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1637 N825NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1679 N826NWDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 1701 N827NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1716 N828CAAc Spe 13 LLC · Orlando, FLBuilt 2012 · S/N 1279 N828NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1720 N829NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1721 N830NWDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 1769 N831NWDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 1783 N851NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0609 N852NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0614 N853NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0618 N854NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0620 N855NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0621 N856NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0631 N857NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0633

Back to AD 2009-18-19 R1