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.

N624RPMaho Bay Partners LLC · Newark, DEBuilt 2015 · S/N 4263N624RSSr22 Delta Hotel LLC · Lafayette, LABuilt 2011 · S/N 3816N624SABout Bertram J Trustee · Los Gatos, CABuilt 2019 · S/N 1950N624SRN3809 Kilo LLC · Wilmington, DEBuilt 2007 · S/N 2561N624TELenbob Aviation LLC · Southaven, MSS/N TH-1588N624VAEkl Aviation LLC · Oklahoma City, OKBuilt 2023 · S/N 9570N624YSnc Investments LLC · Mesa, AZBuilt 2026 · S/N 11299N6255JAzimuth Aviation LLC · Mechanicsburg, PABuilt 1996 · S/N E-3019N6258NTango Victor Aviation LLC · Kingsburg, CABuilt 1978 · S/N 340A0449N625CBPowers Brothers Real Estate · Henderson, TXBuilt 2005 · S/N 1391N625CDTurner David C · Clinton Township, MIBuilt 2005 · S/N 1636N625HWBsw Acceptance Inc · Muleshoe, TXBuilt 1993 · S/N TH-1694N625JLTurbulent Returns LLC · Minneapolis, MNBuilt 1980 · S/N 414A0508N625JSJsl Aviation LLC · Nashville, INBuilt 2013 · S/N 0446N625LEKeystone Flyers LLC · Brevard, NCBuilt 2017 · S/N 1504N625LKB8 LLC · Florence, ORBuilt 2025 · S/N 10416N625SMAstute Wing Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2448N625TBGeneral Aerospace Co LLC · Great Falls, VABuilt 2001 · S/N 30-0061N625TRVictor Pathways Management LLC · Newport Beach, CABuilt 2005 · S/N 1730N625VSHeritage Airplane One LLC · Tullahoma, TNBuilt 2005 · S/N 1517N6262KBrz Air LLC · Beaumont, TXBuilt 1979 · S/N P21000395N6267YZero Four Twelve LLC · Clovis, NMBuilt 1981 · S/N 21064313N6269NJuliet Tango Capital LLC · Saginaw, MIBuilt 1978 · S/N 340A0454N626BGAmazing Concepts LLC · Thousand Oaks, CAFirst renewal noticeBuilt 2010 · S/N 0009N626DPCockpitto LLC · Acampo, CABuilt 2024 · S/N 10376N626EEBedichek Robert C · Covina, CABuilt 2020 · S/N 2067N626FPlane Fun Inc Tr Trustee · Snellville, GABuilt 2007 · S/N 2489N626HHFlightline II LLC · Little Rock, ARBuilt 2021 · S/N 2381N626HMRb Aviation LLC · Tyler, TXBuilt 1981 · S/N 340A1280N626JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 2322N626MEAero Middleton LLC · Belleville, WIBuilt 2024 · S/N 10022N626MTEmtac Sr20 LLC · Palm Beach, FLBuilt 2024 · S/N 10173N626PTDriven Equity LLC · Grand Junction, COBuilt 2021 · S/N 2293N626PZBaja Bay Club LLC · Irvine, CABuilt 2026 · S/N 11433N626REAv Air Lease LLC · Albuquerque, NMBuilt 2008 · S/N 3167N626RFFranklin Air LLC · West Palm Beach, FLBuilt 2020 · S/N 2233N626SGChewning Charles Steven Trustee · Cary, NCBuilt 2023 · S/N 9447N626SRPf Aviation LLC · Birmingham, ALBuilt 2006 · S/N 2001N626TRWevob LLC · Thomasville, GABuilt 2006 · S/N 2242N626TTNacho Plane LLC · Provo, UTBuilt 2019 · S/N 2018N6270XLees Robert A II · Mesa, AZBuilt 1980 · S/N U20605851N6271BCountry Flyin Inc · Homestead, FLBuilt 1977 · S/N U20603839N6274AA V T210 LLC · Palmdale, CABuilt 1979 · S/N 21063517N6276XWj Bolton Farms LLC · Mark Tree, ARBuilt 1978 · S/N 340A0460N6277ZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N U20606211N6278YTown & Country Aviation LLC · Sunnyvale, CABuilt 1981 · S/N 21064318N627HECrinkle Aviation LLC · Indianapolis, INBuilt 2019 · S/N 4855N627PMRichardson David J Trustee · West Memphis, ARS/N 29-0332N627PWSattofas Air LLC · Gilbert, AZBuilt 2007 · S/N 2793N627RGSummer Flight LLC · Selbyville, DEBuilt 2004 · S/N 1243
Back to AD 2012-10-13