AD 2012-10-13

Registered aircraft · 13,306

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-10-13')
    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-10-13')
  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.

N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468N375RBMarinella Leasing LLC · Chandler, AZBuilt 1998 · S/N E-3155N375RRRegistered aircraftBuilt 2020 · S/N 4961N375SBPrecision Aerobatics Inc DBA · Santa Margarita, CABuilt 2019 · S/N 1937N375THRbm Records And Promotion LLC · Clinton, OHBuilt 2024 · S/N 10060N375TT4two9 Aviation LLC · Princeton, FLBuilt 2017 · S/N 4550N3761PSky Rollers LLC · Merritt Island, FLBuilt 1978 · S/N P21000053N376BCKunz Paul C · Midway, UTBuilt 2006 · S/N 2186N376CDWestern Chancellor LLC · Fort Worth, TXBuilt 2005 · S/N 1425N376PDStriplin Donald B · Mammoth Lakes, CABuilt 2004 · S/N 41018N376RHSeckel Dean · Mount Vernon, WABuilt 1998 · S/N EA-612N3777SStuart Guy · Owosso, MIBuilt 2000 · S/N E-3351N377ALKairis Perry A · High Point, NCBuilt 2018 · S/N 4622N377AMJohnstone Inc · Wilsonville, ORS/N E-63N377BCMelcor Aviation LLC · Hopkinton, MABuilt 2022 · S/N 8996N377CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1022N377CFCohen Rolando S · New York, NYBuilt 1974 · S/N 20700275N377DZCsc Capital Holdings LLC · Nashville, TNBuilt 2017 · S/N 1636N377JJThree L Aviation LLC · Victor, NYBuilt 2007 · S/N 2646N377JS270 Aviation LLC · Elizabethtown, KYBuilt 1979 · S/N 340A0672N377MRMaquinarias Repuestos Inc · Miami, FLBuilt 2002 · S/N 0268N377PCBenson Fred B · Cle Elum, WABuilt 2018 · S/N LIV-377N377RGGruett Gregory C · Lititz, PABuilt 2022 · S/N 2470N377SRAero Pacific LLC · Kentfield, CABuilt 2024 · S/N 9764N377TXFauber Dan · Granbury, TXBuilt 2020 · S/N 4950N377X3 Jrks Flying LLC · Jackson, MIBuilt 2012 · S/N 0298N378CTamavo Inc · Baltic, SDBuilt 2008 · S/N 3235N378FJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 40076N378GLReel Trip LLC · Knightdale, NCBuilt 2009 · S/N 3433N378JHPtj Associates LLC · La Canada Flt, CABuilt 2022 · S/N 8932N378PHRegistered aircraftBuilt 2022 · S/N 8690N378SStarr William E · Eagle River, AKBuilt 1979 · S/N U20604967N378TAFull Time Betty LLC · Friday Harbor, WABuilt 2020 · S/N 2160N378WTFeeser Flight Services LLC · Odessa, TXBuilt 2014 · S/N 0882N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803N3796GSantos Aviation LLC · Chico, CABuilt 1977 · S/N 310R0914N3799PCt Services LLC · Albuquerque, NMBuilt 1978 · S/N P21000055N379CDOptimal Aircraft Management Mi LLC · Sanford, MIBuilt 2005 · S/N 1465N379SRSweetwater General Contracting LLC · Cumming, GABuilt 2006 · S/N 1928N379TWTanglewood Aviation LLC · Fort Mill, SCBuilt 1981 · S/N 414A-0616N37BAAmbler Robert L · San Diego, CABuilt 2001 · S/N 40020N37CLAlexander Wolf Corp · Reno, NVBuilt 2022 · S/N 8745N37EWKundel Andrew R · Muscatine, IAS/N U20602997N37GMCraft Engineering Associates Inc · Hampton, VABuilt 1979 · S/N 340A0684N37GTBig Bang Air LLC · Wichita, KSBuilt 2025 · S/N 10571N37KHKlmk LLC · Beaumont, TXS/N 4760N37LGBrody Michael J · Truckee, CAS/N 1279N37LTValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10775N37MGWood Ronald G · Weatherford, TXBuilt 1997 · S/N 29-0110N37PB37pb Inc · Seattle, WABuilt 1972 · S/N 21059737
Back to AD 2012-10-13