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.

N510QSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5326 N510RCRc Aviation Services Inc · San Juan, PRBuilt 2015 · S/N 560-6197 N510TKTk Constructors Inc · Muncie, INBuilt 2000 · S/N 560-5091 N510UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3858 N510VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5207 N511BFAmentum Services Inc · Fort Worth, TXBuilt 2024 · S/N 2350 N511LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 2193 N511VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5212 N511WRAir Wilderness LLC · Wisconsin Dells, WIBuilt 2024 · S/N 560-6359 N512BBTechline Inc · Austin, TXBuilt 2021 · S/N 2078 N512GVBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 5512 N512LLMcminn Law Firm Llp · Austin, TXBuilt 1999 · S/N 560-5023 N512PMEbts LLC · New York, NYBuilt 2009 · S/N 4167 N512RJRegions Commercial Equipment Finance LLC · Birmingham, ALBuilt 2008 · S/N 4124 N512VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5308 N513CCAir Floss One LLC · Carrollton, TXBuilt 2007 · S/N 560-5678 N513DJCccnj F2000-169 LLC · Windermere, FLBuilt 2002 · S/N 169 N513KDKd Aviation 51 LLC · Portland, ORBuilt 2002 · S/N 184 N513MARichport Air LLC · Miami, FLBuilt 2003 · S/N 5019 N513VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5322 N513VVInterstate Aviation LLC · Henderson, NVBuilt 2000 · S/N 560-5126 N514VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5337 N5150VMacon Aero Connections LLC · Macon, GABuilt 2008 · S/N 560-5776 N515CPFac Logistics LLC · Rocky Mount, NCBuilt 2006 · S/N 560-5626 N515KSCentral Iowa Aviation LLC · Ankeny, IABuilt 2002 · S/N 211 N515TCCentral Iowa Aviation LLC · Ankeny, IAS/N 452 N515VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5391 N516DGFalcon Air LLC · Los Angeles, CAFirst renewal noticeBuilt 2000 · S/N 116 N516JAKings Aviation Corp · Garden City, NYBuilt 1991 · S/N 089 N516JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1302 N516WWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5516 N517DWColleen Corp · New Castle, DEBuilt 2013 · S/N 5417 N517JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1327 N517MEBbk Partners LLC · York, PABuilt 2008 · S/N 560-6005 N517TWGtw Corp · Jupiter, FLBuilt 2008 · S/N 5209 N518ERTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 1305 N518GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5618 N518GPG550 Msn 5051 Leasing LLC · Miami Beach, FLBuilt 2004 · S/N 5051 N518GSG S Transport Inc · San Antonio, TXBuilt 2016 · S/N 4353 N518SSFalconsn100 LLC · Roslyn, NYBuilt 1999 · S/N 100 N518VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5488 N519AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5119 N519BCAlta 777 LLC · Salt Lake City, UTS/N 32321 N519EP Ksep LLC · Dublin, TXBuilt 2008 · S/N 560-5768 N519JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1398 N519JDDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 198 N519KCCsb Services Inc · York, NEBuilt 2015 · S/N 1519 N519UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3881 N519VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5510 N51CAOklahoma Jet 560-5234 LLC · Ponca City, OKBuilt 2002 · S/N 560-5234

Back to AD 2012-26-15 R1