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.

N155SRSmedley Charles A · Medford, ORBuilt 2006 · S/N 1924N155THEs Aviation LLC · Memphis, TNBuilt 2006 · S/N 1965N155ZPennsylvania College Of Technology · Williamsport, PABuilt 1981 · S/N TJ-368N1560WHigh Performance Aircraft Inc · El Cajon, CABuilt 1997 · S/N E-3097N1560YPacific Integrated Handling · Tacoma, WABuilt 1994 · S/N TH-1717N1561BLamberton Dale F · Brush Prairie, WABuilt 1996 · S/N E-2993N1561GDusky Aviation LLC · Atlanta, GABuilt 1994 · S/N E-2854N1561LRegistered aircraftBuilt 1994 · S/N E-2856N1561TUmanzor Daniel A · S San Fran, CABuilt 1994 · S/N CE-1777N1562FPatton Janet · Denton, TXBuilt 1994 · S/N E-2857N1563BShulman David A · Frisco, TXBuilt 1994 · S/N CE-1776N1563EZulu Alpha LLC · Naperville, ILBuilt 1989 · S/N E-2473N1563RNovember One LLC · Trophy Club, TXS/N E-2858N1563TN1563t LLC · Sheridan, WYS/N 414-0278N1564DAwy LLC · Bentonville, ARBuilt 1994 · S/N E2905N1564LWhipple Cory · Senatobia, MSBuilt 1976 · S/N TK-6N1564RKm Unlimited LLC · Fallbrook, CABuilt 1988 · S/N EA-487N1565XCutting Paul P · Wellington, FLBuilt 1994 · S/N E-2853N1566KShaw David C · Santa Barbara, CABuilt 1989 · S/N TH-1549N1566URegistered aircraftBuilt 1994 · S/N E-2872N1566W66 Whiskey LLC · Atlanta, GABuilt 1994 · S/N TH-1713N1567NAuburn Simflight LLC · Auburn, ALBuilt 1989 · S/N TH-1567N15688Moses & Associates Inc · Gainesville, FLBuilt 1988 · S/N TH-1542N156ASkymook Aviation LLC · Beaver Falls, PABuilt 1977 · S/N TK-56N156AKCress LLC · Dover, DEBuilt 2017 · S/N 1609N156JBSully Air LLC · Atlanta, GABuilt 2001 · S/N 40019N1570CMottern Edward Thomas · Greenwood, SCBuilt 2003 · S/N 0569N1570GTurner Michael D · Greenwood, SCBuilt 1989 · S/N E-2512N1570NUp N Down Adventures LLC · Calera, OKBuilt 1994 · S/N TH-1715N1576MSkyline Aviation Services LLC · Miramar, FLBuilt 1977 · S/N 21061948N157ATJasper Dane · Santa Rosa, CABuilt 2014 · S/N 4157N157DFair Haven Aviation LLC · San Francisco, CABuilt 2025 · S/N 10402N157ESCirrus Sr22 4386 Inc · Wilmington, DEBuilt 2016 · S/N 4386N157JHHendren Aviation LLC · Gravette, ARBuilt 2019 · S/N 4873N157JRSoft Landings LLC · Myrtle Beach, SCBuilt 1991 · S/N TH-1639N157NNewsome Jeffrey S · Blackwell, OKBuilt 1976 · S/N TJ-52N157PGN777sb LLC · Helena, MTBuilt 2025 · S/N 11064N157SGRichland Aviation Inc · Sidney, MTBuilt 1973 · S/N 340-0154N157SRWildcat Aviation LLC · South Beach, ORBuilt 2022 · S/N 9024N157TXHlebichuk David D · Montgomery, TXBuilt 2005 · S/N 1669N157VRoco Air LLC · San Antonio, TXBuilt 2005 · S/N 1472N157WFHelping Hands Partners II LLC · Wilmington, DEBuilt 2016 · S/N 1392N158BJbc Holdings LLC · Yarmouth, MEBuilt 2007 · S/N 2831N158BHB58 LLC · Granger, INBuilt 1988 · S/N TH-1540N158CFFrederick Cheryl A · Taylor, TXBuilt 2009 · S/N 158N158KSBowerman Marvin · Montgomery, TXBuilt 1982 · S/N TJ-419N158NRoss Adam · Texarkana, TXBuilt 1981 · S/N EA-197N158RMWings Lc · Baltimore, MDBuilt 1988 · S/N TH-1543N158RSRegistration Pending · Wallace, CARegistration pendingBuilt 1981 · S/N TJ-359N158SWFern Leasing Corp · Larkspur, CABuilt 1999 · S/N TH-1921
Back to AD 2012-10-13