Skip to content

Registered aircraft · 1,257

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

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 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 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 N801AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0889 N801UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 686 N802AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0924 N802UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 690 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

Back to AD 2000-11-21