OpenAirDocs.org
AD 2012-16-13

Registered aircraft · 737

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-16-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-16-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.

N410TMCass Brian O · Raleigh, NCBuilt 1998 · S/N JCS137N411BDFort Charles W Jr · Show Low, AZBuilt 2003 · S/N 0501304N4123PBroce Donald S · Rosamond, CABuilt 2012 · S/N F-13-12-10N412PLFischer Joachim W · Foothill Ranch, CABuilt 2022 · S/N 121327N413FJefts Larry G · Kunia, HIBuilt 2011 · S/N F-11-03-04N413WHZiegler Aviation LLC · Minneapolis, MNBuilt 2013 · S/N AC169N41534Tat Networks And Aviation LLC · Bend, ORBuilt 2004 · S/N 150SN9120804KIT49N418EVNationwide Aviation LLC · Hudson Oaks, TXBuilt 2025 · S/N 418/USN418JGJordan Kenneth L · Grants Pass, ORBuilt 2014 · S/N 77536N419USMelbourne Flight Training LLC · Melbourne, FLBuilt 2025 · S/N 419/USN4204QGreen Gary Dale · Valdez-Cordova, AKBuilt 2017 · S/N 329N422KCWade Karen H · Eloy, AZBuilt 2007 · S/N 130N422UAlba Leasing Services LLC · Scottsdale, AZBuilt 2019 · S/N 292/USN423CBHelle Donald D · Chandlersville, OHBuilt 2004 · S/N 486N424BFRegistered aircraftBuilt 2007 · S/N 07SC026N4275URobinson Ronda R · Livermore, CABuilt 1991 · S/N 0791211N429SSBohrnsen Geoff C · Philipsburg, MTBuilt 2008 · S/N 1005417N429YHDickau Perry · Hollis, NHBuilt 2010 · S/N IPP10-398N430WSWind Mountain Aviation LLC · Stevenson, WABuilt 2019 · S/N 1710N432DKDunnagan Steven A · Little Rock, ARBuilt 2026 · S/N AC297N432WSHuie John E · Burnet, TXBuilt 2011 · S/N 0210539N4334HBrown Leland E · Vandergrift, PAS/N 026/20011991N434YDRegistration Pending · Manchester, KYRegistration pendingBuilt 2015 · S/N 001N43615Baker Franklin E · Montgomery, ILBuilt 2006 · S/N 06-233N4362CEdson Larry A · Kettering, OHBuilt 2006 · S/N 06-232N436EVTecnam U S Inc · Sebring, FLBuilt 2026 · S/N 436/USN4381GDuda Edward F · David City, NEBuilt 2005 · S/N 08980854N438JEMachon Brett · Medford, WIBuilt 2007 · S/N 11041621N438WFFuller Wm Douglas · Boise, IDBuilt 2011 · S/N HCU088N43DRReed Dennis P · Scottsdale, AZS/N COB912S062N4415GBryant Dennis G · Loganville, GABuilt 2001 · S/N 000 549N44313Skalberg Bob W · Richfield, MNBuilt 2008 · S/N SOGXXXSOHK0513N4445TTampa Bay Aviation Inc · Clearwater, FLBuilt 2019 · S/N 273/USN4449Cunningham Richard E · Lafayette, CAS/N 81HBS048N444RQOtteson Ralph · Manteca, CAS/N 03960706N445FPFreer James M · Evergreen Park, ILBuilt 2007 · S/N 068N445RAWeatherly Lloyd W · Wittmann, AZBuilt 2008 · S/N 243N4462JSmith Douglas E · Trotwood, OHBuilt 2007 · S/N CAK03971SN447VBBisbing R Michael · Olney, TXBuilt 2013 · S/N 06-10-51-548N448JWWilliams John T Trustee · Redlands, CABuilt 1998 · S/N 01JTN44ARMelech John Daniel · Nevada, MOBuilt 2024 · S/N KA09074155N44TNMoore Aviation LLC · Cedar Springs, MIBuilt 2023 · S/N VSWX1270029N450UAW S Aviation Services LLC · Johns Island, SCBuilt 2025 · S/N 420/USN452KFHildebrand Russell W · Chandler, AZBuilt 2006 · S/N DCS115N452SABallard William C · Pine Level, NCBuilt 2007 · S/N LSA011N454FBGeiger Scott A · Whitehall, MIBuilt 2012 · S/N 1LK540CN456JPJones Benn D · Bell, FLBuilt 1997 · S/N 10-5-92 KPN456JTSmathers Jeffrey J · Molalla, ORBuilt 2004 · S/N S9404-0009N456PTHuizenga Gregory D · Belle Fourche, SDBuilt 2020 · S/N 001025N456WSJones Steven D · Slidell, LAS/N 07SC076
Back to AD 2012-16-13