OpenAirDocs.org
AD 2012-01-07

Registered aircraft · 248

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-01-07')
    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-01-07')
  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.

N823TTIson Todderick J · Calhan, COBuilt 2016 · S/N 0214604N83LGMeuer Livia · Tullahoma, TNBuilt 2022 · S/N 08180080N841EMMcneil Edward W · Saint Petersburg, FLFirst renewal noticeBuilt 2009 · S/N AC133LN850KS&K Aviation LLC · Helena, MTBuilt 2013 · S/N 1LK569CN859MCAhmar Shaikh Enterprises Inc · Waco, TXBuilt 2013 · S/N M00979N85KDKade Aircraft Ltd · Wilmington, DEBuilt 2012 · S/N 1LK529CN874CBArmour Anthony E · Dalton, GABuilt 2015 · S/N JA403-08-14N877DCWest Desert Aviators · Fairfield, UTBuilt 2010 · S/N 0110535N87BNChapple Elizabeth J · Lake Forest Park, WABuilt 2016 · S/N 20161902N887DLCsc Enterprises Inc · Atlanta, GABuilt 2017 · S/N 12-014N888MJMahon Ross M · Kirkland, WABuilt 2016 · S/N 1DK462CN890TAStroud James · Ocala, FLBuilt 2014 · S/N 090N905DHTango Alpha Sierra LLC · Berthoud, COBuilt 2016 · S/N AC213N9085NG-Dawg LLC · Highlands, NCBuilt 2006 · S/N JAESC0019N90AHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 12-016N90PGImage Aviation Services LLC · Wilmington, DEBuilt 2001 · S/N 11-065N911XYSimmons Maxwell · Hayward, CABuilt 2015 · S/N JA 413-09-14N913ALAerotrust Services Corp Trustee · Wilmington, DEBuilt 2021 · S/N 12-040N914AGGubbini Paul G · New Port Richey, FLS/N USA220713N914AKWilliams Kenneth Lee · Palmer, AKBuilt 2020 · S/N JA299-05-13N914CRVerroi Timothy A · Beaufort, SCS/N 12165151014N914CSNance Joseph W · Pagosa Springs, COS/N 53CN914HTGarro Chris P · Fortuna, NDBuilt 2017 · S/N 001N914KDPax River Flyers LLC · Annapolis, MDBuilt 2011 · S/N 007001N914MTDa Choppa LLC · Lago Vista, TXBuilt 2014 · S/N M01113N914MVSmith John R · Greensboro, NCBuilt 2009 · S/N 22-08-5134N914RXCacek Thomas E · Crescent City, FLBuilt 2009 · S/N 1MK453CN914SASmith Air LLC · Wilson, WYBuilt 2012 · S/N KA11219208N914TTYobbka Joseph C · Burnham, ILBuilt 2007 · S/N 039N914TUMeyer Aircraft LLC · Sebring, FLBuilt 2017 · S/N AC-235N914TXAviation Metrics LLC · Dayton, OHBuilt 2007 · S/N 001N914WTPeterson David D · Bonners Ferry, IDBuilt 2012 · S/N 1DK418CN914XLBorger Robert L · Corinth, TXBuilt 2008 · S/N A221N914XSKean Stephen R · Lakeway, TXBuilt 1998 · S/N A001XSN914XXFitzgerald Robert S III · Westfield, MAS/N JA 288-02-13N917BAHawaii Rotor Adventures LLC · Waialua, HIBuilt 2007 · S/N 11-109N925KAAnderson Karl A · Grant, ALBuilt 2009 · S/N 1DK468CN937LCAnderson David · Chambersburg, PABuilt 2015 · S/N 123/2015N938HUGregory David A · Westmoreland, TNS/N 22106114N944AGWilde Jeffrey L · Chuckey, TNBuilt 2017 · S/N RSUK/CAVP/003N959DHHunt Duane Gerard · Napanee OntarioNon-citizen corporation, flight hours not reportedBuilt 2013 · S/N 1LK564CN95BMNelson Jeff · Darby, MTBuilt 2009 · S/N 36.832N9753Southeast Soaring LLC · Miami Beach, FLBuilt 2021 · S/N 12-036N989LWOrange Sky LLC · Naples, FLS/N 001N995JQualitair LLC Trustee · MichelstadtS/N 11-083N9984LAgri-Stor Co East · Blackfoot, IDBuilt 2023 · S/N A424ULSN999HBManhattan Management Corp · Wilmington, DEBuilt 2014 · S/N 089N9MAActualized Business Solutions Inc · California, MDS/N 1090
Back to AD 2012-01-07