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.

N220ADSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2010 · S/N 3697N220AMLungley George · New Albany, OHBuilt 2010 · S/N 3635N220DBGrosso John A · Princeton Junction, NJBuilt 1999 · S/N 30-0035N220DPMyrick Richard Leon · Williamson, GABuilt 1966 · S/N 380N220EBJag Aviation LLC · South Easton, MABuilt 2024 · S/N 10325N220GDJoseph M De Lecce Trustee · Prather, CAS/N 414A0459N220GKHotel Bravo Aviation LLC · Alexandria, OHBuilt 2009 · S/N 3437N220KMBlue Streak Aviation LLC · Dupont, WABuilt 2017 · S/N 1536N220LATochima Air LLC · Laredo, TXBuilt 2023 · S/N 9230N220MRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 3779N220PKCirrus Design Corp · Knoxville, TNBuilt 2010 · S/N 0004N220RGWalden Hill III LLC · Signal Mountain, TNBuilt 2024 · S/N 10182N220RPDanzig Peter B · Menlo Park, CABuilt 1988 · S/N E-2438N220SQValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11124N220SRBriar Flyer LLC · Bedford, NHBuilt 2002 · S/N 0391N220TJJaco Oil Co · Bakersfield, CAS/N 21063139N220VAVision Air LLC · Rapid City, SDBuilt 2026 · S/N 11192N220VFVision Flight LLC · Knoxville, TNBuilt 2017 · S/N 1622N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194N220WRExecutive Services Inc · Columbus, MSBuilt 1994 · S/N E-2909N2210YN2210y LLC · San Antonio, TXBuilt 2000 · S/N 29-0212N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711N22126Compassion Medflight LLC · Pikeville, KYBuilt 2024 · S/N 10017N2215CEnvialo LLC · Vail, COBuilt 2023 · S/N 9416N2215YNaran Ashish H · Brookhaven, GABuilt 2000 · S/N 30-0049N22166Reading Jared T · Uvalde, TXBuilt 2000 · S/N 29-0225N22184Rosene Richard W · Newport, RIBuilt 2000 · S/N 29-0227N2218MBerry Jeffrey M · Palmetto Bay, FLBuilt 2000 · S/N 30-0050N2219MDubya Aviation LLC · Broken Arrow, OKBuilt 1998 · S/N E3149N221ALAardvark Ventures LLC · Ada, MIBuilt 2022 · S/N 8538N221AWChapman Lawrence N · Placerville, CAS/N 0758N221AXN221ax LLC · Scottsdale, AZBuilt 2024 · S/N 10007N221BMOne Bravo Mike LLC · Wilmington, DEBuilt 2006 · S/N 1901N221CDJaffee Robert · Victoria, MNBuilt 2001 · S/N 0093N221CEN221ce LLC · Covington, GAS/N 0021N221CLValiair Lc Trustee · Casper, WYBuilt 2021 · S/N 2298N221EDRegistration Pending · Christiansburg, VARegistration pendingBuilt 2022 · S/N 8774N221EGGerbair LLC · Kirkland, WABuilt 2022 · S/N 2475N221FDPhantom Phlyer LLC · Monument, COBuilt 2025 · S/N 10398N221FSBurke Garrett · Jupiter, FLBuilt 2025 · S/N 10514N221GCK2b Aviation LLC · Bluffton, SCBuilt 2022 · S/N 8984N221GTStar B LLC · Helena, MTBuilt 2015 · S/N 1150N221JAInner Air Ity LLC · Pensacola, FLBuilt 2007 · S/N 2416N221KDSwf Elite Properties LLC · Plymouth, MIBuilt 2025 · S/N 10950N221KTCorcoran Aviation LLC · Murrieta, CABuilt 2024 · S/N 10347N221PGSkytec Group LLC · Chevy Chase, MDBuilt 2021 · S/N 2256N221PHFlorida Flight Physical LLC · Crystal River, FLBuilt 2019 · S/N 4872N221PLN312dy LLC · Austin, TXBuilt 2023 · S/N 9609N221PPLive Pilot Training LLC · Ankeny, IABuilt 1987 · S/N 46-08064N221RPPastor Randall J · Granite Bay, CABuilt 2004 · S/N 0878
Back to AD 2012-10-13