Registered aircraft · 5,537

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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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.

N637NGAirporter59 LLC · Jupiter, FLBuilt 2016 · S/N 1637 N637NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6436 N638JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2802 N638MFR O P Aviation Inc · Morristown, NJBuilt 2014 · S/N 41392 N638NGN638ng LLC · Woodward, OKBuilt 2016 · S/N 1638 N638NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6463 N639ACBank Of Utah Trustee · Salt Lake City, UTS/N 1162 N639BGBristow US LLC · New Iberia, LABuilt 2013 · S/N 41343 N639CFChevron U S A Inc · Picayune, MSBuilt 2025 · S/N 41604 N639DSChevron USA Inc · Picayune, MSBuilt 2011 · S/N 41262 N639GGChevron USA Inc · Picayune, MSBuilt 2012 · S/N 41308 N639JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2814 N639JKChevron U S A Inc · Picayune, MSBuilt 2025 · S/N 41607 N639MCChevron USA Inc · Picayune, MSBuilt 2012 · S/N 41288 N639MMChevron USA Inc · Picayune, MSBuilt 2009 · S/N 41216 N639NAChevron USA Inc · Picayune, MSBuilt 2013 · S/N 41326 N639NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6487 N639WWChevron USA Inc · Picayune, MSBuilt 2009 · S/N 41229 N63DZSteel Town Equipment LLC · Exton, PAS/N 276 N63FSIron Senergy Legacy LLC · Louisville, KYBuilt 2000 · S/N 132 N63NGBurgess Skyways LLC · Olathe, KSBuilt 2012 · S/N 1363 N63NXRamos Aviation Services LLC · Arvada, COBuilt 2014 · S/N 1463 N63WJKaylan Paige Leasing LLC · Grand Junction, COBuilt 2005 · S/N 278 N640AKIei Transport LLC · Dover, DEBuilt 2018 · S/N 560-6258 N640JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2832 N640KC21st Century Equipment LLC · Scottsbluff, NEBuilt 2008 · S/N 1076 N640NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6507 N640WBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5416 N641AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30595 N641JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2848 N641KCGill Air LLC · Dexter, MOBuilt 2009 · S/N 1141 N641MSMs Aviation II LLC · Philadelphia, PABuilt 2007 · S/N 560-5684 N641NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6566 N641SUIowa State University Of Science And Technology · Ames, IABuilt 2004 · S/N 560-5504 N641UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25091 N642NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6586 N642TKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2002 · S/N 145642 N642UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25092 N642VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3670 N643AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 32776 N643JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2871 N643NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6616 N643TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5295 N643UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25093 N644JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2880 N644NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7156 N644RVFrankcrum Corporate Inc · Clearwater, FLBuilt 1996 · S/N 22 N644UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25094 N645ACBank Of Utah Trustee · Salt Lake City, UTS/N 1259 N645CCL3harris Technologies Flight Capital LLC · Greenville, TXS/N 5496

Back to AD 2012-26-15 R1