Skip to content

AD 2011-19-01 R1

Registered aircraft · 1,371

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:2011-19-01-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:2011-19-01-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:2011-19-01-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:2011-19-01-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:2011-19-01-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:2011-19-01-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.

N776XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 2209 N778XFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4127 N779JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3811 N783HWSpectre Air Capital LLC · Horseshoe Bay, TXS/N 1817 N784JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4578 N789JBJetblue Airways Corp · Long Island, NYBuilt 2011 · S/N 4612 N793JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4647 N794JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4904 N796JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5060 N8001NAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5678 N8009TAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5788 N801AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0889 N801UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 686 N8027DAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6437 N802AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0924 N802UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 690 N8030FAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6552 N8031MAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6595 N803AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0931 N803UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 0748 N804AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1043 N804JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5142 N804UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 0759 N805AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1049 N805JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5148 N805UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0783 N806AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1056 N806JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5302 N806UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0788 N807AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1064 N807JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5312 N807UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0798 N808AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1088 N808UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0804 N809AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1111 N809JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5349 N809UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0825 N810AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1116 N810UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0843 N811UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0847 N812AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1178 N812UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0850 N813AWWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 1223 N813UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0858 N814AWWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 1281 N814UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0862 N815AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1323 N815UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0867 N816AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1350 N816UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0871

Back to AD 2011-19-01 R1