Skip to content

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

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.

N776XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 2209 N777ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29585 N777AZWilmington Trust Company Trustee · Wilmington, DEBuilt 2002 · S/N 29743 N777BHQuanta Aviation Equipment Company LLC · Wilmington, DEBuilt 2015 · S/N 1535 N777EFEmpire Aviation LLC · Collierville, TNBuilt 2024 · S/N 2387 N777KLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5421 N777LALogistic Air Inc · Reno, NVS/N 32894 N777LXFrontenac Properties Inc · Chesterfield, MOBuilt 2007 · S/N 560-5736 N777QLMed Air LLC · Lawrenceville, GABuilt 2002 · S/N 216 N777RBSchwik Air LLC · Springfield, ILBuilt 2006 · S/N 560-5641 N777UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 26916 N777XYCair Leasing LLC · Wilmington, DEBuilt 1987 · S/N 27 N777YJBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5403 N778ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29587 N778CRCmr LLC · Chicago, ILBuilt 2006 · S/N 4056 N778LGLogistic Air Inc · Reno, NVS/N 32895 N778UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26940 N778XFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4127 N779ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29955 N779AZPittco Aviation LLC · Memphis, TNBuilt 2007 · S/N 4089 N779JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3811 N779UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26941 N77DZZkd Air LLC · Houston, TXBuilt 2001 · S/N 560-5168 N77EABank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 2099 N77FWestrock Group LLC · Little Rock, ARBuilt 1997 · S/N 51 N77JDJd Capital LLC · Fort Smith, ARBuilt 2001 · S/N 560-5190 N77SDFlight Level Services LLC · Danville, KYBuilt 2008 · S/N 1001 N77TFRegistered aircraftBuilt 2013 · S/N 870 N78001United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27577 N78002United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27578 N78003United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27579 N78004United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27580 N78005United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27581 N78008United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29478 N78009United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29479 N78013United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29861 N78017United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31679 N78060United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29455 N780ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29956 N780BHVanlex Flight Services LLC · Omaha, NEBuilt 2011 · S/N 431 N780CRCmr III LLC · Chicago, ILBuilt 2019 · S/N 5594 N780EAkfl3 LLC · Farmingdale, NYBuilt 2009 · S/N 5258 N780HPTennessee Department Of Safety & Homeland Security · Nashville, TNS/N 57335 N780KSMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2005 · S/N 5091 N780SPScashley Falcon LLC · Los Angeles, CABuilt 1991 · S/N 93 N780UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26944 N781ACWintrust Asset Finance Inc · Frisco, TXBuilt 2021 · S/N 57440 N781ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29586 N781KBRipley Entertainment Inc · Orlando, FLBuilt 2016 · S/N 560-6214 N781SLBb & Ryder LLC · Conway, ARBuilt 2001 · S/N 560-5162

Back to AD 2012-26-15 R1