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.

N104YRichter-Sand Robert J · Albuquerque, NMBuilt 2017 · S/N KA11316217N1080Skram Airlines LLC · Wurtsboro, NYBuilt 2013 · S/N 1LK579CN112GSale Reported · SigmaringenSale reportedBuilt 2000 · S/N 37N113RSBlades Over Me LLC · Vero Beach, FLBuilt 2020 · S/N 071N115KBFly Away Inc · Lackawanna, NYBuilt 2014 · S/N 1LK588CN11SKStemme N11sk LLC · Missoula, MTBuilt 2019 · S/N 12-030N120STStemme USA Inc · West Columbia, SCBuilt 2026 · S/N 12-062N1227ZFisichella David C · Falmouth, MABuilt 2024 · S/N A017N123TNMontana Retirement Center LLC · Kalispell, MTBuilt 2010 · S/N 006N124AFinck Charles F · Liberty Lake, WABuilt 2008 · S/N 1MK 442 CN124WLarson Bruce W · Urbana, OHBuilt 2024 · S/N JA428-12-14N129DCMoonbeam Management LLC · Longwood, FLBuilt 2014 · S/N 1LK574CN129GFFrick Gary A Trustee · Marion, INS/N 126N12AYYerly Alan K · Valrico, FLBuilt 2009 · S/N A54AN12RTRegistration Pending · Duncan, OKRegistration pendingBuilt 2020 · S/N 1966N133RDGodfrey Kirk P · Cameron Park, CABuilt 2007 · S/N 1DK396CN134ABSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N PFA 247-13879N136RTJc/Rc Ventures LLC · Key West, FLS/N 1859N140VTDetert Bradley · Valparaiso, INBuilt 2014 · S/N 11-140N147DKSpecialty Aerospace LLC · Grand Rapids, MIBuilt 2013 · S/N 1LK568CN14EPBatterman Eric P · Princeton, NJBuilt 2009 · S/N 1DK399CN151SGGurevich Alan · Seattle, WABuilt 2021 · S/N 12-041N152SGSuedla Holding LLC · Wilmington, DEBuilt 2022 · S/N 12-045N152TUCampbell Steven G · Newport Beach, CABuilt 2016 · S/N 052N155MLawton John Mann · Whitwell, TNBuilt 2018 · S/N 53418N1564Stick & Rudder LLC · London, KYBuilt 2015 · S/N 160/2015N158MBKropelin Barry R · Waxhaw, NCBuilt 2020 · S/N 08175451014N1688BChen Chris · Monrovia, CABuilt 2013 · S/N V00123N16BMWilson Joshua A · Mckinney, TXBuilt 2022 · S/N PM007N175PMMoulton William M · Meredith, NHBuilt 2007 · S/N 1 MK 436CN177BKThompson Bruce G · Ithaca, NYBuilt 2015 · S/N 1MK466CN17VPAvstar Inc · Seattle, WABuilt 2016 · S/N JA433-01-15N18WCSale Reported · SigmaringenSale reportedBuilt 2000 · S/N 38N1971PSebesta Kenneth D · Boston, MABuilt 2011 · S/N 015N1985AJp Aero Holdings Inc · Kalispell, MTBuilt 2019 · S/N 315N1DLThunderbird Aviation LLC · Littleton, COBuilt 1999 · S/N 11-031N208XIdahoxray LLC · Saint Anthony, IDBuilt 2019 · S/N S70411072N211KAKlinefelter Kevin J · Bishop, CAS/N 01N212XWittstruck Ivan W Jr · Greeley, COBuilt 2018 · S/N 54218N216PMBolinger Andy L · La Follette, TNBuilt 2012 · S/N V00065N219GHBurrichter Steven · Scottsdale, AZBuilt 2010 · S/N 05080007N220TSCondor LLC · Ponte Vedra Beach, FLBuilt 2013 · S/N 025N222DPatterson Lawrence Jr · Tampa, FLBuilt 2005 · S/N 1MK378CN226HCSafeway Aviation LLC · Richmond, TXBuilt 2016 · S/N 120N228FTCole Matthew Dewayne · Trenton, GAS/N A-115N228XMidgley Edward S · Sugar Grove, ILBuilt 2014 · S/N 085N232SSHaynes John H · Gainesville, GABuilt 2015 · S/N JA 327-11-13N2341RMagniflight LLC · Pensacola, FLBuilt 2020 · S/N 24192284N237AECollins Alan M · Delta, COBuilt 2011 · S/N S70204-011N241GGThompson Tom III · Byers, COBuilt 2012 · S/N 24127574
Back to AD 2012-01-07