OpenAirDocs.org
AD 2012-16-13

Registered aircraft · 737

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-16-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-16-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.

N672CAWest Desert Aviators · Fairfield, UTBuilt 2006 · S/N 966N677TSMakepeace Mike · El Dorado, ARBuilt 2016 · S/N 021N678PTwin Eagle Air LLC · Morrison, ILBuilt 2013 · S/N F-13-12-09N682SCMcdonald Billie L · Howe, IDBuilt 2013 · S/N JA287-02-13N68BRJorgensen Marty · Dallas Center, IABuilt 2013 · S/N KA12188236N68MSSpoke Craig · Lillian, ALBuilt 2021 · S/N 04-2019-0814N68PSDahl Scott · Big Flats, NYBuilt 2023 · S/N 1192 SFM 912 LSAN6907Fbn Aviators LLC · Perkasie, PABuilt 2008 · S/N 1 DK 446N6912TMid-Atlantic Air Ventures Inc · Richmond, VABuilt 2010 · S/N 047N69NAAngello Thomas · Malabar, FLS/N 06071818N700JSSecor John M · Sellersburg, INBuilt 2007 · S/N 07SC039N701JVGromala Ivan A · Cloverdale, CABuilt 2012 · S/N 7-6875N701TNHammerdog LLC · Lafayette, COBuilt 2012 · S/N 7-6416N701XCSale Reported · Montoursville, PASale reportedBuilt 2006 · S/N 7-5625N7024LHatcher Dwayne E · Highland Village, TXBuilt 2004 · S/N C1091N702PRArroyo Jose R · Las Vegas, NVBuilt 1995 · S/N 10015N7035YMaune Jeffrey A · Union, MOBuilt 2005 · S/N 001N70450Berger Stephen C · Perris, CABuilt 2000 · S/N 01011402N7049UAutrey Randy D · Bethel, MES/N IPPS-313N7051SOmni Auto Repair LLC · Port Allen, LABuilt 2007 · S/N P91280506W3N705BMRosen Michael J · Burlington, VTBuilt 2008 · S/N 1N705FPWebb Mark E · O Brien, FLBuilt 2007 · S/N 174N7063VNetcher Daniel R · Ely, NVBuilt 2002 · S/N SKR 0203 166N708FPEvans Arthur L · Brownsburg, INS/N 182N70948Kirkendall Marlin R · Waynesfield, OHBuilt 2002 · S/N 2000N709RSeverance Ryan P · Greenbush, MEBuilt 2003 · S/N 0302274N70ZZClark Dolphe S · Bishop, CABuilt 2013 · S/N F-12-05-05N713GSHarrison Richard Kevin · Las Vegas, NVBuilt 2024 · S/N 24 SI 241N714QHBriscoe James S · Cleveland, GABuilt 2020 · S/N 1211571N717TBCurtis Steven E · Miles City, MTBuilt 2007 · S/N 095N71LWCreswell Braelan R · Bradley, MES/N 001N71RROverwatch Tools Inc · Chesapeake, VABuilt 2021 · S/N VSWX1210100N721TSAuen Jeffrey G · Hunt Valley, MDBuilt 2015 · S/N AC026N724JFNew Horizons Aviation LLC · Stevensville, MDBuilt 2018 · S/N M01462N724TAWilliams John D · Geneva, OHS/N SS08912COHK0529N727PDGoldman James L · Media, PABuilt 2013 · S/N 000593N734WSun South Of Jennings LLC · Jennings, LABuilt 2017 · S/N AC-211N73861Rotschy Grayson B · Yacolt, WABuilt 2026 · S/N S97050214N739TAElite Approach LLC · Chesterfield, MOBuilt 2015 · S/N 139/USN739ZRegistration Pending · Spring Branch, TXRegistration pendingBuilt 2007 · S/N 200173N73XTBlixt Scott · Montgomery, MNBuilt 2006 · S/N XT912-0136N742SVDiscover More LLC · Kalispell, MTBuilt 2023 · S/N VSWX1270031N7446BJones Robert M · Big Lake, AKBuilt 2017 · S/N 7-7580N747FKVan Schoonhoven Peter · Battle Ground, WABuilt 2016 · S/N 824SM 912N7507PWoodriff Roger Lee · Three Forks, MTBuilt 2007 · S/N XT-912-0167N75092Sexton Jerry T · Hedgesville, WVBuilt 2003 · S/N SKR0302295N750DWWagner Douglas A · Tucker, GABuilt 2023 · S/N 75-10034N750PDTcb Solutions LLC · Milledgeville, GABuilt 2012 · S/N 75-8139N751JMRosenbloom Robert A · Santa Cruz, CABuilt 2011 · S/N F-11-11-06N75453Vasseghi Kamran · Marina Del Rey, CABuilt 2007 · S/N 001VK
Back to AD 2012-16-13