Skip to content

Registered aircraft · 2,914

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

N512VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5308 N513ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35192 N513SNM48513 LLC · Esters, FLBuilt 1994 · S/N 48513 N513VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5322 N514ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35193 N514VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5337 N515VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5391 N516ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39044 N516JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1302 N517ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35197 N517JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1327 N518ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35693 N518UAUnited Airlines Inc · Chicago, ILBuilt 1990 · S/N 24871 N518VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5488 N519ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 36482 N519JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1398 N519VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5510 N520ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 36481 N520JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1446 N520NANasa Langley Research Center · Hampton, VAS/N 86-0206 N520VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5595 N521FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48478 N521JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1452 N521SHGlobal Crossing Airlines Inc · Miami, FLS/N 2840 N521VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5651 N522AXBc Aircraft Leasing LLC · Albuquerque, NMBuilt 1988 · S/N 48315 N522FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48476 N522VLBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5776 N523ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 35194 N523FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48479 N523JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1506 N523VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6014 N524ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35195 N524JBJetbule Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1528 N524VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6161 N525ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35692 N525FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48565 N525VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6332 N526ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35196 N526JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1546 N526VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 6470 N527ASAlaska Airlines Inc · Seatac, WAS/N 35694 N527JLJetblue Airways Corp · Long Island, NYBuilt 2001 · S/N 1557 N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705 N528ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35695 N528FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48623 N529ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 35198 N529FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 48624 N529JBJetblue Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1610 N530ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 36578

Back to AD 74-08-09 R2