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.

N802SRBohon Jose S · Corona, CABuilt 2006 · S/N 1886N802SSBlue Sky Inc · Wilmington, DEFirst renewal noticeBuilt 2005 · S/N 41063N8033HArde Wayne A · Simla, COBuilt 2003 · S/N 0644N8036TPaysse John G · Hanford, CABuilt 1980 · S/N EA-150N8038ZBas Part Sales LLC · Greeley, COBuilt 1990 · S/N E-2568N803DBCalifornia Retail Builders Inc · Fresno, CABuilt 2021 · S/N 2258N803NHCoastal Helicopters Inc · Panama City, FLBuilt 1992 · S/N E-2697N803PKCarnine Legal Pllc · Mount Vernon, ILBuilt 2021 · S/N 5048N803SRInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N 1959N803TSTns Aviation LLC · Coto De Caza, CABuilt 2017 · S/N 1634N803WFWhiskey Foxtrot LLC · Algonquin, ILBuilt 2019 · S/N 1933N8043BT & A Aviation 2 LLC · Saint Petersburg, FLBuilt 1991 · S/N E-2618N8044UCrowe Stephen R Trustee · Lake Ozark, MOBuilt 1992 · S/N E-2708N8045UCox Clifford J · Armada, MIBuilt 1990 · S/N E-2570N804ACOrs22t LLC · Upland, CABuilt 2026 · S/N 11274N804BABell Aviation LLC · Walnut Creek, CABuilt 2020 · S/N 2230N804BRLarsen Technology LLC · The Villages, FLBuilt 2018 · S/N 1713N804CLDickerson Richard S · Powhatan, VABuilt 2016 · S/N 4360N804DBWaterside Aviation LLC · San Jose, CABuilt 2008 · S/N 3212N804DKParsloe Robert J · Falmouth, MEBuilt 2017 · S/N 1583N804DLFarhad Sigari M D F A C S P C · Marina Del Rey, CABuilt 2021 · S/N 2356N804HSBb Co LLC · Parker, COBuilt 2016 · S/N 1403N804LP1st Gen Aviation LLC · Richmond, VABuilt 2024 · S/N 10210N804LXBeepfly Inc · Los Angeles, CABuilt 2009 · S/N 3488N8051UChandler Christian J · Ashfield, MABuilt 1990 · S/N TH-1607N8052MEcho Romeo LLC · Stamford, CTBuilt 1977 · S/N 21062031N8055ZAir Hatzis LLC · Baton Rouge, LABuilt 1990 · S/N E-2572N805GHCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11610N805JCBig Sky Baron Lc · Missoula, MTBuilt 1980 · S/N TJ-253N805LLAerojet USA LLC · Knox, INBuilt 2003 · S/N 0741N805MXKinsale Associates LLC · Everett, WABuilt 2006 · S/N 2237N805PMColwell Blue Berry Farm LLC · Ellsworth, MEBuilt 2005 · S/N 29-0391N805PRValiair Lc Trustee · Casper, WYBuilt 1985 · S/N 414A1206N805SERc Electronics Inc · Helena, MTBuilt 2002 · S/N 0430N805SGCharlie Golf Aviation LLC · Moorpark, CABuilt 2023 · S/N 9254N805SRDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 2006 · S/N 1998N805VMazel Wings LLC · Camden, DEBuilt 2026 · S/N 11203N805WTCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11498N8061VCheairs William T · Covington, TNBuilt 2003 · S/N 0649N8064NSierra Hotel Aviation LLC · Spartanburg, SCBuilt 1990 · S/N E-2578N8067UPalmer Eric E · Tucson, AZBuilt 1992 · S/N EA-536N8068QCreative Consulting Partners LLC · Fargo, NDBuilt 1974 · S/N 414-0503N8068USan Diego Flight Corp · San Diego, CABuilt 1992 · S/N E-2725N8069UV115 Aviation LLC · Mount Juliet, TNBuilt 1992 · S/N E-2727N806BMAlbatross Aviation LLC · Ponte Vedra Beach, FLBuilt 2015 · S/N 4186N806CDLewis Melvin Lee Jr · Fisk, MOBuilt 2001 · S/N 0106N806DKCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11623N806ECFlynn Development Corp · Clearwater, FLBuilt 2004 · S/N 0839N806GCCoastal Aircraft Services Inc · Gulf Shores, ALBuilt 2017 · S/N L2K-224N806JDProbe Aviation LLC · Laveen, AZBuilt 2022 · S/N 8829
Back to AD 2012-10-13