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.

N408NGHt Air LLC · Exeter, NEBuilt 2013 · S/N 1408N409AMN409am Leasing LLC · Lexington, KYBuilt 2010 · S/N 1204N409BGSpur Aviation Services Lc · Twin Falls, IDBuilt 2011 · S/N 1274N409DAUS Government · Washington, DCBuilt 2023 · S/N 2290N409LHLaboratory Corporation Of America Holdings · Burlington, NCBuilt 2024 · S/N 2409N40BGAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 2041N40GFN40 Air LLC · Great Falls, MTBuilt 2021 · S/N 2142N40GPBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 45-2061N40HCHoar Aviation LLC · Birmingham, ALBuilt 2018 · S/N 560-6247N40PCUnit B LLC · Stillmore, GAS/N 515N40PDLear Flight LLC · Reno, NVBuilt 2008 · S/N 2111N40PVSeabreeze One LLC · Leawood, KSBuilt 2010 · S/N 406N40XRPalace Aviation Inc Trustee · Wilmington, DEBuilt 2005 · S/N 2028N410ACBank Of Utah Trustee · Salt Lake City, UTS/N 3045N410GXWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 01199N410LSLitania Sports Group Inc · Champaign, ILBuilt 2011 · S/N 420N411AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4411N411AJXcel Jet Management Inc · Newark, DES/N 2011N411AVAircol 9 · Wilmington, DES/N 4011N411CDRegistered aircraftBuilt 1994 · S/N 138N411CEUS Bank Na · Marshall, MNBuilt 2019 · S/N 57370N411ECAir Ports Holdings LLC · Weare, NHBuilt 2007 · S/N 560-5734N411KQSolid Axle Management II LLC · Marshall, TXBuilt 2002 · S/N 560-5226N411LLGlen Hill Sky LLC · Oakbrook Terrace, ILBuilt 2015 · S/N 4329N412ABXls Partners Ky LLC · Louisville, KYBuilt 2007 · S/N 560-5752N412GAWilmington Trust Co Trustee · Providence, RIBuilt 2024 · S/N 2390N412JSPeace Rocking III LLC · Charlottesville, VABuilt 2014 · S/N 1466N412MWSig Aviation LLC · Wilmington, NCS/N 1099N412TJ400tj Inc · Newport Beach, CABuilt 2013 · S/N 4278N413AFBerry Genetics Inc · Portsmouth, NHBuilt 2024 · S/N 2413N413AGPljk LLC · Leechburg, PABuilt 1998 · S/N 560-5017N413CEUS Bank Na · Marshall, MNBuilt 2019 · S/N 57376N413CMCargo Aircraft Management Inc · Wilmington, OHS/N 26988N413DWDmw Aviation LLC · Marshfield, MABuilt 2010 · S/N 560-6074N413HAMap Transport LLC · Lexington, KYBuilt 2001 · S/N 147N413UUUniversity Of Utah · Salt Lake City, UTBuilt 2009 · S/N 1100N414RGFink Sky LLC · El Paso, TXS/N 441N415BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5312N415DLDolan Law Firm Pc · San Francisco, CABuilt 2013 · S/N 1436N415DSNexa Aviation LLC · Burlingame, CAS/N 5090N415HSWoodford Enterprises LLC · Fort Lauderdale, FLBuilt 2012 · S/N 560-6110N415JHBristow LLC · Lake Charles, LABuilt 2009 · S/N 41224N415QSRegistered aircraftBuilt 2005 · S/N 4014N415XTX-Ray Tango Inc · San Rafael, CABuilt 2021 · S/N 2144N416AVAircol 19 · Wilmington, DEBuilt 2009 · S/N 4167N416VGlacier Leasing LLC · Grand Rapids, MIBuilt 2000 · S/N 560-5109N417JDTrmsi Inc · Plymouth Meeting, PABuilt 2009 · S/N 560-6041N417NGRipley Aviation LLC · Leesburg, VABuilt 2013 · S/N 1417N417SKSkn Air LLC · Monterey, CABuilt 2016 · S/N 1661N418ABNix Patterson Llp · Austin, TXS/N 537
Back to AD 2012-26-15 R1