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.

N75478Woodriff Lee · Three Forks, MTBuilt 2008 · S/N IPP8-366N75479Skyview Powered Parachute Inc · Hutchinson, KSBuilt 2008 · S/N IPP8-365N757XLRegistration Pending · Tyler, TXRegistration pendingBuilt 2016 · S/N AC190N760JPGuilford Jones III · Marathon, TXBuilt 2011 · S/N D97912SOHK0264N7623CValenzuela Francisco · Indianapolis, INBuilt 2007 · S/N 07SC063N763ACGone LLC · Hartwell, GABuilt 2008 · S/N JAESCO153N765WPrentiss Barton P · Sequim, WABuilt 2004 · S/N 164900N767NEJorgensen Jay G · Albany, NYBuilt 2007 · S/N 07SC045N769BWKerschner Jay W · Valley Mills, TXS/N 120456N771JCWater Landings LLC · Lady Lake, FLS/N AC152N773HGWilliams Stephen Jesse · Cullowhee, NCBuilt 2022 · S/N JAESC0139N774BJMans Andrew J · Aledo, TXBuilt 2009 · S/N JA-179-11-08N775TWWalraven Thomas M · Kaewkawlin, MIBuilt 2009 · S/N 10061774N7777XCooper Casey L · Marana, AZBuilt 2020 · S/N 719N777NGN M G Aviation LLC · Salisbury, NCBuilt 2007 · S/N 07SC059N7794TMork Laird J · Harris, MNBuilt 2007 · S/N 186N781NWFairbanks Kelly E · Twin Falls, IDBuilt 2019 · S/N E9030N7826TLouie Kenneth G · San Rafael, CABuilt 2010 · S/N 7-6513N7840HSmith David N · Scottsdale, AZBuilt 2014 · S/N S60701-056N788UAlba Leasing Services LLC · Scottsdale, AZBuilt 2019 · S/N 295/USN789CGSearey Adventures LLC · Conroe, TXBuilt 2010 · S/N 1LK490CN78AVBrotto Daniele C · Parkville, MDBuilt 2012 · S/N 063N795BRScheffler Larry · Pelican Rapids, MNBuilt 2017 · S/N 04131033N797STMonette Joseph Robert · Lexington, KYBuilt 2012 · S/N 2012 1518N798VSSchilling James R · Ocklawaha, FLBuilt 2017 · S/N 1015621N799JTCorrigan Patrick R · Hondo, TXBuilt 2010 · S/N 11081909N79BJBosch Jerome C · Leominster, MABuilt 2024 · S/N V9503-0028N79DEHpx Soar LLC · Auburn, NHBuilt 2006 · S/N 200.172N79GPCamenisch Ranches LLC · Bellvue, COBuilt 2023 · S/N MLAG0012N7YWCumiskey Ryan D · Kissimmee, FLS/N DY 180/2007N800SABoomerang Lsa Southwest LLC · Wichita Falls, TXS/N C21N800XLWalk Michael J · Englewood, FLBuilt 2009 · S/N H2004N80195Haefeli Thomas · Del Norte, COBuilt 2006 · S/N 0301007N801HTS&S Aero Inc · Ponce Inlet, FLBuilt 2024 · S/N 191N802TCSmith Barkley W · Royston, GABuilt 2012 · S/N JA7-10-08N806GKBrunet Kevin · Whitehall, MTBuilt 2012 · S/N 110800050N8073SMiller Denver B · Libertytown, MDBuilt 2003 · S/N 2001N8084HWhitesell N G · Bryson City, NCBuilt 2009 · S/N IMK343CN808GHBank Of Utah Trustee · Salt Lake City, UTS/N MO1603N808JBXray Mike Inc · Wilmington, DEBuilt 2007 · S/N 9113N808JDGermann Hans · Boise, IDBuilt 2006 · S/N 0095N808NRBigham Michelle Mary · Dunlap, TNBuilt 2007 · S/N 0108N8097DReminga Tyrone J · Muskegon, MIBuilt 2007 · S/N 07-241N8097VBaldwin Thomas A Jr · Puyallup, WABuilt 2007 · S/N 07-242N80JMMadden James C · Salt Lake City, UTBuilt 2009 · S/N JAESC 0025N80MSLefs LLC · Trenton, MIBuilt 2023 · S/N 02-2020-0812N8102RHarper Phil · Bowdon, GABuilt 2005 · S/N T05052N810SMSierra Mike LLC · Wilmington, DEBuilt 2007 · S/N 07SC035N813XDDugan Michael S · Cornelius, ORBuilt 2018 · S/N 0813597N814ANKonzelmann Andreas · New London, MNBuilt 2014 · S/N S70202005
Back to AD 2012-16-13