AD 2007-19-13

Registered aircraft · 2,446

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
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:2007-19-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:2007-19-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.

N973NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31219N973UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4893N974ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30098N974JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7448N974UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4898N975ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29549N975JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7520N975UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4935N976ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30099N976JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7529N976NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 33243N976UYUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5235N977JEJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8641N977NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31225N977UYAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5409N978ANMsn 30100 Trust · Wilmington, DEBuilt 2001 · S/N 30100N978JBJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7584N978NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31226N978UYAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5422N979ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 29568N979JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7627N979NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31228N979UYAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5763N980ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33203N980AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3980N980JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7631N980NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31229N980UYAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5795N981ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29569N981JTJetblue Airways Corporation · Long Island City, NYBuilt 2017 · S/N 7692N981NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31230N981UYAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5800N982ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31067N982JBJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7815N982NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31231N982VJAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5374N983ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29570N983JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7739N983NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33337N984CMCargo Aircraft Management Inc · Wilmington, OHS/N 03274N984JBJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7874N984NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31234N985CMCargo Aircraft Management Inc · Wilmington, OHS/N 1928N985JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7798N985NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31233N986ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7046N986JBJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7907N986NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31236N987AMAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7079N987ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31069
Back to AD 2007-19-13