Skip to content

Registered aircraft · 1,354

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-05-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-05-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-05-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-05-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-05-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-05-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.

N601NKBank Of Utah Trustee · Sale Lake City, UTBuilt 2010 · S/N 4206 N602NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4264 N603JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2352 N603NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4321 N604AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1196 N604NKBank Of Utah Trustee · Salt Lake City, UTS/N 4431 N605JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2368 N605NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4548 N606JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2384 N606NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4592 N607JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2386 N607NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 4595 N608JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2415 N608NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4902 N609NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4951 N611NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 4996 N612JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2447 N612NKRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 2012 · S/N 5029 N613JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2449 N613NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5042 N614NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5132 N615JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2461 N615NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5159 N616NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5370 N617NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5387 N618JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2489 N618NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5458 N619NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2013 · S/N 5517 N620NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5624 N621JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2491 N621NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5672 N622NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5804 N623JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2504 N623NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5861 N624JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2520 N624NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5880 N625JBJetblue Airways Corporation · Long Island City, NYBuilt 2005 · S/N 2535 N625NKUmb Bank Na Trustee · Salt Lake City, UTS/N 5954 N626NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5999 N627JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2577 N627NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6082 N628NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6193 N628VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 2993 N629JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2580 N629NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6300 N630JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2640 N630NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 6304 N630VABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3101 N631NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2014 · S/N 6327 N632AVBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5632

Back to AD 2000-05-21