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.

N57PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0300N57PGShirman Leon · Redwood City, CABuilt 2007 · S/N 2674N57RJD&J Training Planes LLC · Logan, UTBuilt 2016 · S/N 4382N57RXVolar Ix LLC · Edmond, OKBuilt 2026 · S/N 11295N57RZSierra Tango Ventures LLC · Monte Sereno, CABuilt 2009 · S/N 3439N57SAFort Wayne Aircraft LLC · Fort Wayne, INBuilt 2024 · S/N 10093N57TUKagley Larry D · Greenwood, SCBuilt 2002 · S/N 0377N57TWBc & Tw Flying Service LLC · Hot Springs, ARBuilt 1982 · S/N EA-288N57XTLiss Jonathan L Md · Columbus, GABuilt 2024 · S/N 10001N580EN580e LLC · Hickory, NCBuilt 1995 · S/N TH-1758N580SRNose Up Speed Aviation LLC · Durango, COBuilt 2007 · S/N 2580N5813MMehta Aviation LLC · Birmingham, MIBuilt 2021 · S/N 2414N5816PWolf Michael A · Rutledge, TNBuilt 1996 · S/N 29-0087N581CBColorado Baron LLC · Ketchum, IDBuilt 1979 · S/N TJ-233N581CDLig Air Services LLC · New York, NYBuilt 2022 · S/N 8972N581CVCpc Aviation LLC · Helena, MTS/N 0367N581PFFox Arrow 542 LLC · Jonesboro, ARBuilt 1993 · S/N TH-1707N581PSBonanza Aviation LLC · Wilmington, DEBuilt 1999 · S/N TH-1903N581SACalifornia Industrial Rubber Co Inc · Fresno, CABuilt 2000 · S/N TH-1942N581SDDakota Cross Winds LLC · Bismarck, NDBuilt 2008 · S/N 3171N581SHShowtime Aviation LLC · Frostproof, FLBuilt 2001 · S/N TH-2011N581THCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11605N5825MLee Brian P · Kent, WABuilt 1969 · S/N 310P0125N5826CBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 402C0050N5827MHopland Steve · Johnson City, TNBuilt 1972 · S/N 340-0051N582SBHardy Gordon H · Belmont, CABuilt 1978 · S/N TJ-172N582TSage Sky LLC · Telluride, COBuilt 2024 · S/N 10367N582TAWiday John P · El Cajon, CABuilt 1979 · S/N TJ-191N583CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N 1809N583CFFox Aviation LLC · Hattiesburg, MSBuilt 1997 · S/N LIV143N584BSch Aviation Inc Trustee · NorfolkBuilt 2007 · S/N 2330N584CDBrothers David M Trustee · Cainsville, MOBuilt 2005 · S/N 1652N584CFGreenspace Of Virginia LLC · Forest, VABuilt 2022 · S/N 8584N584CPThorpe LLC · Jupiter, FLS/N 3353N584DBWhiskey Bravo Air LLC · Dover, DEBuilt 2018 · S/N 1767N584DFHangar 3 LLC · Milledgeville, GABuilt 1990 · S/N TH-1605N584DSRose Michael · Prescott, AZBuilt 1981 · S/N TJ-343N584DTTiger Flight LLC · Florence, SCBuilt 1995 · S/N TH-1745N584MBCenterline Holdings Inc · Camden, DES/N TK-151N584MWRela Matthew V · Monroe, NJBuilt 1991 · S/N TH-1615N584SRThunder Richard · San Diego, CABuilt 2007 · S/N 2378N584WKing Air Ny LLC · Schenectady, NYBuilt 1993 · S/N TH-1699N5854AColorado High Plains Aviation Ltd · Englewood, COBuilt 2002 · S/N 0171N5858Campbell Joshua · Dallas, TXBuilt 2018 · S/N 1821N5858PMatherne David M · Houma, LAS/N TJ446N585ABHh Aircraft LLC · Englewood, COBuilt 2009 · S/N 3499N585CDE And J Holdings 25 LLC · El Dorado, ARBuilt 2005 · S/N 1661N585CFBuzzing Above II LLC · Tampa, FLBuilt 2022 · S/N 8585N585ECMc Aviation II LLC · West Palm Beach, FLBuilt 2019 · S/N 4816N585GBCirrus Design Corp · Knoxville, TNBuilt 2013 · S/N 3959
Back to AD 2012-10-13