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.

N78FJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 78 N78QWilmington Trust Co Trustee · Wilmington, DES/N 1649 N78UTUnited Therapeutics Corp · Silver Spring, MDBuilt 2018 · S/N 57322 N78XLGarmin International Inc · Olathe, KSBuilt 2005 · S/N 560-5578 N79011United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29859 N790ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30251 N790CPConocophillips Alaska Inc · Anchorage, AKBuilt 2018 · S/N 970 N790DCDynamic Healthcare Solutions DBA · Dallas, TXBuilt 2007 · S/N 4070 N790HPTennessee Department Of Safety & Homeland Security · Nashville, TNBuilt 2024 · S/N 57519 N790LTGbl LLC · Woodbury, MNBuilt 1993 · S/N 129 N790TXEgret Flyers LLC · Winston Salem, NCBuilt 2008 · S/N 560-5790 N790Z2514 LLC · Dover, DEBuilt 1996 · S/N 31 N791ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30254 N791CANational Air Cargo Group Inc DBA · Orlando, FLBuilt 2026 · S/N 70547 N791UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26933 N792ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30253 N792CANational Air Cargo Group Inc · Orlando, FLBuilt 2026 · S/N 70548 N792UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26934 N793ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30255 N793AXAeroacq Partners LLC · Laud By Sea, FLS/N 23143 N793JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4647 N793MGHaupt LLC · Jupiter, FLBuilt 2009 · S/N 5263 N793UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26946 N794ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30256 N794JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4904 N794UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26953 N795ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30257 N795CANational Air Cargo Group Inc · Orlando, FLBuilt 2026 · S/N 70549 N795CRTime 2 Fly 2.0 LLC · Richmond, VABuilt 2014 · S/N 5474 N795MMBrc LLC · Oakland, CABuilt 2015 · S/N 1518 N795RBPalm Beach County Sheriffs Office · West Palm Beach, FLBuilt 2019 · S/N 57382 N795SPLockton Enterprises Inc · Kansas City, MOBuilt 2013 · S/N 5448 N795UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26927 N7965MChasing The Sun LLC · Bronx, NYBuilt 2012 · S/N 14501164 N796ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30796 N796JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5060 N796JHGpc Aviation Investments LLC · Fresno, CABuilt 2006 · S/N 306 N796UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26931 N797ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30012 N797AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1985 · S/N 23147 N797HDMario Murillo Ministries · Lafayette, TNBuilt 2000 · S/N 135 N797LDThomas Aviation LLC · Wichita, KSBuilt 1996 · S/N 24 N797TWMulti-State Realty Investments LLC · Yukon, OKBuilt 2000 · S/N 111 N797UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26924 N797WCLand Sea Air Leasing Corp · Sylmar, CABuilt 2001 · S/N 140 N798ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30797 N798CANational Air Cargo Group Inc · Orlando, FLBuilt 2026 · S/N 70550 N798SDScenic Ventures Leasing LLC · Middletown, DEBuilt 2021 · S/N 2141 N798TAgeless Mens Health Holdings Inc · Scottsdale, AZBuilt 2003 · S/N 560-5307 N798UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26928

Back to AD 2012-26-15 R1