OpenAirDocs.org
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.

N240CVMooney International Corporation Inc · Kerrville, TXBuilt 2015 · S/N 33-0001N240ESSchmidlin Eric · Dublin, OHBuilt 2007 · S/N L2K237N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221N240MBFlying Brick LLC · Monroe, NCBuilt 2006 · S/N 1880N240SQMigster LLC · Miami, FLBuilt 1975 · S/N 310R0273N240SRMontana Aircraft Trust Inc Trustee · Bozeman, MTS/N 2411N240WARight Traffic LLC · Ellenton, FLBuilt 2013 · S/N 3940N24165Yukon Helicopters Inc · Bethel, AKBuilt 1978 · S/N TK-78N24182Robert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1978 · S/N TJ-136N2418NDah Aviation LLC · Boerne, TXBuilt 2022 · S/N 8953N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012N241BSAdventure Airways LLC · Sacramento, CABuilt 2008 · S/N 421014N241CMFalgout Scott · La Place, LABuilt 2002 · S/N 0357N241DBSequoia Aeronautics LLC · Portland, ORBuilt 2007 · S/N L2K-290N241EBUsd Flyers Inc · Atlanta, GABuilt 2005 · S/N 42065N241FRTrailside Inc · Roseville, CABuilt 2017 · S/N T24002140N241GBPalmer Levi S · Upper Lake, CABuilt 2003 · S/N 42023N241GSCirrus Design Corp · Knoxville, TNBuilt 2010 · S/N 0032N241HHOddson Terrance J · Windom, MNBuilt 2001 · S/N E-3427N241LCD&D Air Services LLC · Mooresville, NCBuilt 2018 · S/N 4731N241LMEntropy Elevation LLC · San Jose, CABuilt 2015 · S/N 1124N241MBFlying Brick LLC · Monroe, NCBuilt 2004 · S/N 0910N241PKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 0102N241SGFalasco Joseph R · Little Rock, ARBuilt 1999 · S/N 29-0196N241SHSky West Aviation Inc Trustee · Albuquerque, NMS/N 0398N241SLHickman Ira · West Richland, WABuilt 2005 · S/N 1283N241TBSoar47llc · Charlotte, NCBuilt 2020 · S/N 4937N241TLAeronuts LLC · Santa Monica, CABuilt 2009 · S/N 3521N241TMSoaring Cessna LLC · Brookeville, MDBuilt 2016 · S/N 4402N241WSSun Moon Star LLC · Springfield, MOBuilt 1999 · S/N TH-1922N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276N2428EHusel Robert · Bend, ORBuilt 2005 · S/N 1307N242ALPapa Docs & Company LLC · Midland, TXBuilt 2025 · S/N 10636N242AZPs1two1 LLC · North Charleston, SCBuilt 2008 · S/N 3182N242CABeaver Air LLC · Houston, TXBuilt 2024 · S/N 10206N242GDodson International Parts Inc · Rantoul, KSS/N 340A0799N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049N242HPGold Spencer M Trustee · Mirror Lake, NHBuilt 2026 · S/N 11384N242KABig River Air LLC · Jackson, MSBuilt 1983 · S/N 340A1802N242KTEthereal Sky LLC · Bloomfield Hills, MIBuilt 2018 · S/N 330006N242KWRegistered aircraftBuilt 2023 · S/N 9602N242LManda Aviation LLC · Bakersfield, CABuilt 2016 · S/N L2K-219N242MBRed Bird Aviation LLC · Waxhaw, NCBuilt 2004 · S/N 0911N242MDSpyder Flights LLC · Manchester, PABuilt 2003 · S/N 29-0292N242MWQualitair LLC Trustee · MichelstadtBuilt 2011 · S/N 0106N242PTOmega Lake LLC · Wilmington, DEBuilt 2017 · S/N 33-0005N242PZFennell Louis A Jr · Johns Island, SCS/N 40037N242RYCity Management Corp · Sunriver, ORBuilt 1978 · S/N P21000036N242SESanco Enterprises · Shoreview, MNBuilt 2022 · S/N 9019
Back to AD 2012-10-13