Skip to content

Registered aircraft · 562

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:2016-08-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:2016-08-13') 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:2016-08-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:2016-08-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.

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:2016-08-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:2016-08-13')
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.

N477AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2013 · S/N 5477 N477UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1514 N478UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1533 N479UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1538 N480UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1555 N481AVAircol 21 · Wilmington, DEBuilt 2010 · S/N 4381 N481UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1559 N482UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1584 N483UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1586 N484UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1609 N485UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1617 N486UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1620 N487UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1669 N488UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1680 N489UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1702 N4901UUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 2680 N490UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1728 N491UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1741 N492UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1755 N493UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1821 N494UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1840 N495UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1842 N496UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1845 N497UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1847 N498UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1865 N503JBJetblue Airways Corp · Longisland City, NYBuilt 1999 · S/N 1123 N504JBJetblue Airways Corp · Long Island City, NYBuilt 1999 · S/N 1156 N505JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1173 N505VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4798 N506JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1235 N506VLBank Of Utah Trustee · Salt Lake City, UTS/N 4828 N507JTJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1240 N507VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4832 N508JLJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1257 N508VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4950 N509JBJetblue Airways Corporation · Long Island City, NYBuilt 2000 · S/N 1270 N509VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5062 N510JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1280 N510VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5207 N511VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5212 N512VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5308 N513VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5322 N514VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5337 N515VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5391 N516JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1302 N517JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1327 N518VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5488 N519JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1398 N519VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5510 N520JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1446

Back to AD 2016-08-13