OpenAirDocs.org
AD 2012-26-15 R1

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
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.

N653AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1003N653CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2003 · S/N 560-5324N653JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3039N653NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8012N653UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25391N654ATRbj Industries Inc · Saint Cloud, MNS/N 574N654AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1050N654CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2005 · S/N 560-5542N654DPSix Five Aviation LLC · Austin, TXBuilt 2008 · S/N 2092N654NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8176N654PDMilk Source LLC · Kaukauna, WIBuilt 2017 · S/N 560-6236N654UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25392N654WAWinchester Air Inc · Winchester, MABuilt 2024 · S/N 560-6363N655AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1075N655JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3072N655NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8376N655QSNetjets Sales Inc · Oklahoma City, OKBuilt 2006 · S/N 560-5655N655TCTlc Aircraft Leasing LLC · Vero Beach, FLBuilt 2002 · S/N 195N655TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5251N655UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25393N656AWU S Bank N A Trustee · Boston, MABuilt 1999 · S/N 1079N656CNCorporate Flight Management Incdba · Smyrna, TNBuilt 2005 · S/N 560-5551N656GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23017N656JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3091N656NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8400N656QSRegistered aircraftBuilt 2007 · S/N 560-5732N656UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 25394N657AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1083N657CNCorporate Flight Management Inc · Smyrna, TNBuilt 2005 · S/N 560-5572N657EZT G I Consulting Services LLC · Concord, CABuilt 2009 · S/N 1097N657GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23018N657JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3119N657PPPeterson Holding Co · San Leandro, CAS/N 340N657UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27112N658AWWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 1110N658JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3150N658NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6736N658UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27113N659AWUS Bank Na Trustee · Boston, MABuilt 2000 · S/N 1166N659GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23140N659JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3190N659NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6770N659UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27114N65CCNbi Holdings LLC · New Bremen, OHBuilt 2008 · S/N 5207N65KLRegency Aviation LLC · Edgewater, MDBuilt 2004 · S/N 5035N65NGGlc Pc-12 LLC · South Bend, INBuilt 2012 · S/N 1365N65WNewark Building Supply LLC · Columbus, OHBuilt 2008 · S/N 1085N66051United Airlines Inc · Chicago, ILBuilt 2000 · S/N 29446N66056United Airlines Inc · Chicago, ILBuilt 2001 · S/N 29451N66057United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29452
Back to AD 2012-26-15 R1