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.

N497HHN497hh LLC · Scottsdale, AZBuilt 2024 · S/N 2398 N497MNHeavenly Express LLC · Winnetka, ILBuilt 2019 · S/N 560-6263 N497NGCwc Aviation LLC · Brainerd, MNBuilt 2014 · S/N 1497 N497SBAdlaur Aviation LLC · St Thomas, VIBuilt 2009 · S/N 5238 N497UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1847 N498DTBell Textron Inc · Fort Worth, TXS/N 57165 N498UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1865 N499AVTeton Leasing LLC · Pocatello, IDBuilt 2005 · S/N 560-5602 N499AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29432 N499GSN499gs LLC · Nashville, TNBuilt 2004 · S/N 2014 N499LATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 1895 N499SCFlying Ace LLC · Danville, CABuilt 2008 · S/N 4135 N49HMFlying Bullet LLC · Grand Island, NEBuilt 2005 · S/N 2036 N4BAMonte Carlo Associates LLC · Santa Ana, CABuilt 2003 · S/N 200 N4CHW&W-Afco Steel LLC · Oklahoma City, OKS/N 2137 N4DAN4da LLC · College Station, TXBuilt 2021 · S/N 604 N4FNBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 41579 N4KSOa Air LLC · Lincoln, NEBuilt 1999 · S/N 560-5035 N4RPN4rp LLC · Missoula, MTBuilt 2017 · S/N 560-6227 N4TDTeton Holdings II LLC · Chicago, ILBuilt 2006 · S/N 4044 N5007EAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5781 N500DWBlack Dog Aviation LLC · Erie, PABuilt 2017 · S/N 1729 N500GQIntellectual Air LLC · Atlanta, GABuilt 2010 · S/N 4191 N500JDBeneficial Endeavors LLC · Wilmington, DEBuilt 2005 · S/N 560-5589 N500JHJ & J Aviation LLC · Crested Butte, COBuilt 2013 · S/N 1400 N500MAAndretti Autosport Aviation LLC · Fort Lauderdale, FLS/N 151 N500MGMerlone Geier Management LLC · San Francisco, CABuilt 2013 · S/N 1405 N500MWFolkvord Family Aviation LLC · Three Forks, MTBuilt 2021 · S/N 2111 N500RLBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4158 N500SXMerlin Aviation LLC · Indianapolis, INBuilt 1999 · S/N 560-5018 N500WGCitation Msn 560-6343 LLC · Wilmington, DEBuilt 2023 · S/N 560-6343 N500XLAbd Equipment LLC · Aledo, TXBuilt 2003 · S/N 560-5335 N501GMSc Transport LLC · Torrance, CABuilt 2017 · S/N 5561 N501KTShaken Aviation LLC · Madison, ALBuilt 2012 · S/N 435 N501MMN501mm LLC · North Little Rock, ARBuilt 1999 · S/N 99 N501QCQuikrete Aircraft Leasing LLC · Atlanta, GABuilt 2013 · S/N 5450 N501UPCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 560-5252 N502BCOnarco2 LLC · Maurice, IABuilt 2000 · S/N 560-5098 N502BGCapital Holdings 209 LLC · Newark, DEBuilt 1995 · S/N 15 N502EGX-Ray Lima Sierra LLC · Springfield, MOBuilt 2004 · S/N 560-5502 N502UPAlliance Aviation Group LLC · Wilmington, DEBuilt 2003 · S/N 560-5310 N502XLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 560-6502 N503AZAmazon.Com Services LLC · Seattle, WABuilt 1991 · S/N 25274 N503DJDodson International Parts Inc · Rantoul, KSBuilt 2001 · S/N 145 N503GSRegistered aircraftBuilt 2003 · S/N 5005 N503GVEmmanuel Group · North Wilkesboro, NCBuilt 2015 · S/N 5503 N503JBJetblue Airways Corp · Longisland City, NYBuilt 1999 · S/N 1123 N503KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 28553 N503QFLmm Holding LLC · Cincinnati, OHBuilt 2001 · S/N 560-5205 N503SHBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 41384

Back to AD 2012-26-15 R1