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.

N767BCCambata Aerospace LLC · Millboro, VABuilt 2013 · S/N 0465N767BKF&E G A Inc · Miami Springs, FLBuilt 2005 · S/N 29-0377N767CMValiair Lc Trustee · Casper, WYBuilt 1992 · S/N E2723N767DFMaurin Edward E III · Grand Junction, COBuilt 1988 · S/N E-2403N767EMGoepfert Lease Company LLC · Joplin, MOBuilt 2006 · S/N L2K-287N767JPPicard Philip A · Clover, SCBuilt 1990 · S/N TH-1583N767JRAzure Aviation LLC · Mount Pleasant, SCBuilt 2023 · S/N 9373N767PLFly Girls LLC · La Verne, CABuilt 2026 · S/N 11400N767RRRed Leasing LLC · Juneau, AKBuilt 1972 · S/N 310Q0455N767SBRegistered aircraftBuilt 2005 · S/N 29-0383N767WTO'Dell Thomas Anthony · Sunnyvale, CABuilt 2010 · S/N 0056N767ZZRegistered aircraftBuilt 2007 · S/N 2410N768CBDk Air LLC · Encino, CABuilt 2019 · S/N 1918N768CDSears William R · Lexington, MABuilt 2004 · S/N 1041N768FSRegistration Pending · Fruita, CORegistration pendingBuilt 2018 · S/N 1738N769ACAircraft Propulsion Leasing LLC · Holland, OHBuilt 1978 · S/N TK-89N769CDSutherland James N · Terrebonne, ORBuilt 2004 · S/N 0932N769EAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0303N769KVFalcon Aviation Inc · West Jefferson, OHBuilt 2023 · S/N 9623N769SROwll Aviation LLC · Baton Rouge, LABuilt 2007 · S/N 2769N769TXRegistration Pending · Henderson, NVRegistration pendingBuilt 2021 · S/N 2469N76ALAldeen Leo · Houston, TXBuilt 2021 · S/N 5057N76BLBravo Lima Corp · Lakewood, COBuilt 1973 · S/N 21059808N76BYViper Aeronautics LLC · Lincoln, NEBuilt 2002 · S/N 0145N76CETri Gen Air LLC · Bedford, VABuilt 2016 · S/N 1447N76CWYatahey LLC · Middletown, DEBuilt 1976 · S/N 310R0695N76DFMtb Aviation LLC · Ormond Beach, FLBuilt 2020 · S/N 2082N76DWNuage Nine Inc Trustee · Wilmington, DEBuilt 2022 · S/N 9005N76KTWarriors With Wings LLC · Zebulon, NCBuilt 1974 · S/N 414-0508N76LKAir Supply Inc · Clearwater, FLBuilt 2018 · S/N 1754N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204N76SVParish Aviation LLC · New Orleans, LABuilt 2020 · S/N 4986N76VVVandersteen Richard J · Hanford, CABuilt 2005 · S/N 3RX118N7702QRobinson Meyer · Daphne, ALBuilt 1970 · S/N 310Q0202N770CAHorse Hill LLC · Napa, CABuilt 2009 · S/N 3418N770CFKopp Adrian D · Brookville, INBuilt 1978 · S/N U20604569N770CTMetza M Kristen · Andrews, NCBuilt 2008 · S/N 2927N770MMButterworth James Blakely · Demorest, GABuilt 2009 · S/N 3405N770SRRiverside Aircraft LLC · Fort Myers, FLBuilt 2006 · S/N 1939N770TPJekkerson LLC · Evergreen, COBuilt 2007 · S/N 2418N770ZZInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N L2K-324N7711GTrans Meridian LLC · Fort Myers Beach, FLFirst renewal noticeS/N P21000072N7719QTurel Stanley · Bend, ORBuilt 1973 · S/N 3400194N771BB406 Mountain Air LLC · Bigfork, MTS/N EA619N771BTRosen Air 71 LLC · Brentwood, TNBuilt 2010 · S/N 3622N771EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0046N771FRDellinger Aero Inc Trustee · Wilmington, DEBuilt 2022 · S/N 8883N771KSWieczorek Michael A · Athens, GABuilt 2005 · S/N 1717N771MPFl072 Aviation LLC · Brentwood, TNBuilt 1974 · S/N 340-0368N771SL3vr Aviation LLC · Annapolis, MDBuilt 2005 · S/N 1405
Back to AD 2012-10-13