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.

N737USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1245 N738USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1254 N740AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6411 N740UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1265 N741AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6617 N741UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1269 N742AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6692 N742PSBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1275 N743AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6739 N744PBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1287 N745AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6746 N745VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1289 N746JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3622 N746UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1297 N747UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1301 N748AVNavigator Aviation II Msn 6862 Trust · Wilmington, DEBuilt 2015 · S/N 6862 N748UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1311 N749USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1313 N750AVNavigator Aviation II Msn 7120 Trust · Wilmington, DEBuilt 2016 · S/N 7120 N750UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1315 N751UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1317 N752USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1319 N753USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1326 N754UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1328 N755AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7437 N755USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1331 N756USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1340 N757UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1342 N758USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1348 N760JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3659 N760USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1354 N762USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1358 N763AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4763 N763JBJetblue Airways Corp · Long Island, NYBuilt 2008 · S/N 3707 N763USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1360 N764USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1369 N765USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1371 N766JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3724 N766USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1378 N767UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1382 N768JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3760 N768USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1389 N769USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1391 N770UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2000 · S/N 1393 N771XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1980 N772XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1997 N773XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 2012 N774XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 2019 N775JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3800 N775XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 2198

Back to AD 2011-19-01 R1