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.

N899SStocks Aviation And Machine Inc · Wilmington, DEBuilt 2002 · S/N 25N899TJN988tj LLC · Okemos, MIBuilt 2025 · S/N 10970N899TTTangtang Gang LLC · Lewes, DEBuilt 2002 · S/N 0203N89ABSkybound Escapes LLC · Daniel Island, SCBuilt 2022 · S/N 8509N89ADClairmont Holdings Vi LLC · St Thomas, VIS/N 402C0115N89BGPegasus Ltd LLC · Farmington, ILBuilt 2012 · S/N 0351N89BPBlackfin Aviation LLC · West Islip, NYBuilt 2020 · S/N 2229N89BTCrow Wing III LLC · Palm Beach, FLBuilt 2019 · S/N 2023N89CRWsg Aviation LLC · Chaffee, MOBuilt 2007 · S/N 2365N89EPBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 21060380N89FJS-Turns LLC · Windermere, FLBuilt 2015 · S/N 4238N89GHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1178N89HWHw Air Lc · Salt Lake City, UTBuilt 2001 · S/N 40016N89KBJet Sense Aviation Aircraft Holdings Corp · Burlington, WIS/N EA-54N89KPRegistered aircraftBuilt 1979 · S/N 21063501N89KWThelen Mark C · Roswell, GABuilt 2007 · S/N 2492N89MNNoffze Michael · West Fargo, NDBuilt 2024 · S/N 10378N89NBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 3680N89NXCardinal Account Services Inc DBA · Mentor, OHBuilt 2004 · S/N 1004N89PBPb Mad Aviation LLC · Pittsburgh, PABuilt 2025 · S/N 11052N89PFBrown Jeffrey T · Sherman, ILBuilt 2003 · S/N 40074N89SNRegistered aircraftBuilt 2026 · S/N 11446N89SWRaw Dog Aviation And Media LLC · Naples, FLBuilt 2024 · S/N 9799N89UMIsbell Services LLC · Tuscaloosa, ALBuilt 2004 · S/N 0971N89WGCirruslysoaring LLC · Carmel, INBuilt 2024 · S/N 9863N8APacific Aviation LLC · Cottage Grove, ORBuilt 1976 · S/N 18502852N8ADChelsea Build LLC · Brenham, TXS/N EA-359N8AEIflyu LLC · Mobile, ALBuilt 2008 · S/N 2999N8BLPro One Janitorial Inc · Chicken, AKBuilt 1970 · S/N 414-0098N8CCMag 3 Aviation LLC · Vidor, TXBuilt 1981 · S/N 21064437N8DADrenk Aviation LLC · Fountain Valley, CABuilt 2021 · S/N 2376N8EYMoore Robert Russel Sr · Austin, TXBuilt 1985 · S/N P21000850N8FBRichland Aviation Inc · Sidney, MTBuilt 1978 · S/N 402B1372N8FMSky Dawg LLC · Winterville, NCBuilt 1997 · S/N E-3068N8KMWolding Jeffrey D · Ashland, WIBuilt 1974 · S/N 21060260N8KTChui Aviation LLC · The Woodlands, TXBuilt 2020 · S/N 4900N8KXTroutman Shaun L · Johnson, KSBuilt 1992 · S/N 37N8LJFlying Mushrooms LLC · New York, NYBuilt 2023 · S/N 9323N8LUMoes Nose Holdings LLC · Washington, DCBuilt 2025 · S/N 10925N8MXMoncrief Rick L · Melba, IDS/N 21062687N8NURbc Aviation LLC · Hollywood, FLBuilt 1966 · S/N T210-0220N8SGSouthern Cross Aircraft LLC · Fort Lauderdale, FLBuilt 2015 · S/N 1176N8SSWeather Modification LLC · Fargo, NDBuilt 1973 · S/N 340-0191N8SZFinch Stanley F · San Marcos, TXBuilt 1987 · S/N 4608079N8TMAdvanced Intelligent Computing Inc DBA · Houston, TXBuilt 1980 · S/N TJ-325N8URLoberg Kirk · Jonesboro, ARBuilt 1999 · S/N TH-1917N8UZAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 42050N8WT8wt LLC · Manakin Sabot, VABuilt 2024 · S/N 9800N8WWLcam Aviation LLC · Springfield, MOBuilt 1976 · S/N TK-43N8WYStockhouse James B · Jackson, WYBuilt 2002 · S/N 40060
Back to AD 2012-10-13