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.

N851FWJohn R Markham Pc · Prescott, AZBuilt 2008 · S/N 2985N851JWRegistration Pending · Prosper, TXRegistration pendingBuilt 2005 · S/N 1477N8523QLifetime Adventures LLC · Bellevue, MIBuilt 1976 · S/N U20603379N8526QKenworthy Winston C · Odessa, TXBuilt 1976 · S/N U20603382N852CDTaylor Charles Garrett II · Pine Bluff, ARBuilt 2002 · S/N 0219N852EWN678z LLC · Colorado Springs, COBuilt 2002 · S/N 0320N852MMMistwood Holdings LLC · Newark, DEBuilt 2014 · S/N 0916N852SDauenhauer Manufacturing Inc · Ketchum, IDBuilt 1978 · S/N P21000081N852TSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 414-0804N852TWKinney Aviation LLC · Bethany Beach, DEBuilt 2023 · S/N 9147N853CFProper Technique LLC · Ooltewah, TNBuilt 2022 · S/N 8539N853CMBishop Thomas G · Port Orange, FLBuilt 2004 · S/N 0982N853JMAutomatedpower Aviation LLC · Flowood, MSBuilt 2015 · S/N 4253N853KTKansas State University Salina · Salina, KSBuilt 1993 · S/N CE-1765N8546QBlack Andrew J · Broomfield, COBuilt 1976 · S/N U20603402N854BCAlmond Grove LLC · Casper, WYBuilt 2008 · S/N 3220N854CBeasley Timber Co Inc · Hazlehurst, GABuilt 2001 · S/N TH-2018N854SDSd Aviation LLC · Menlo Park, CABuilt 2021 · S/N 2247N854SRSunray Properties Inc · Navasota, TXBuilt 2007 · S/N 2670N8554RGichuiri Patrick Nginyah · Chandler, AZBuilt 2004 · S/N 0874N855HSanford Larry D · Edmond, OKBuilt 1982 · S/N 414A0855N855SHHenderson Sarah · Cocoa Beach, FLBuilt 2020 · S/N 059N855TAWoods II Wings Aviation LLC · Oklahoma City, OKBuilt 2005 · S/N 1536N856SRDavark Aero LLC · Grapevine, TXBuilt 2007 · S/N 2834N8576QThompson Robert Lee · Moore, OKBuilt 1976 · S/N U20603432N857AZBb Air Group LLC · Aberdeen, SDBuilt 2005 · S/N 41078N857CDAlbright J Trustee · Gold Canyon, AZBuilt 2002 · S/N 0271N8580QBald Eagle Aviation LLC · Oakley, UTBuilt 1976 · S/N U20603436N858BBEchelon Group Inc · Boise, IDBuilt 1979 · S/N 21063277N858BSSkye Co LLC · South Williamson, KYBuilt 2006 · S/N 2035N858CAMgmb Aero LLC · Mandan, NDBuilt 2024 · S/N 10200N858HPJb Ag Lands LLC · Modesto, CAS/N 1968N858MCRkh Capital LLC · Melbourne Beach, FLBuilt 2023 · S/N 9263N858MLLang Inc · Wilmington, DEBuilt 1980 · S/N TJ-257N858PGAbida Babida LLC · Aspen, COBuilt 2020 · S/N 2095N858RCoussens Jerry D · Davenport, IABuilt 2022 · S/N 4621N858RCTurner Roger Dean · Rockwall, TXS/N 2939N858TLIndiana Flight E2m LLC · Fort Wayne, INBuilt 2011 · S/N 0232N858TNAgl Promotions LLC · Highlands Ranch, COS/N 1858N858TWNorthstar Air Fleet LLC · Mackinac Island, MIBuilt 2017 · S/N 4553N858ZG858gg LLC · Aspen, COBuilt 2019 · S/N 1956N8598QTolley Samuel M · Rangely, COBuilt 1976 · S/N U20603453N859CBoe Ndt LLC · Haysville, KSBuilt 2001 · S/N E-3395N859JFlying Aggies LLC · Louisville, KYBuilt 2006 · S/N 1996N859SRMile High LLC · Bloomington, INBuilt 2007 · S/N 2835N85AMLitchfield Lantz Dr · Las Vegas, NVBuilt 1973 · S/N 414-0435N85BEColeray Aviation LLC · Douglasville, GABuilt 2021 · S/N 2423N85BTAulton New Energy Inc · Arcadia, CANon-citizen corporation, flight hours not reportedBuilt 2024 · S/N 10248N85DAGp Aviation Services LLC · Wilmington, DEBuilt 2004 · S/N 1085N85DPPamperin Holdings LLC · Green Bay, WIBuilt 2026 · S/N 11339
Back to AD 2012-10-13