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.

N204RDMastropietro Richard · Aptos, CABuilt 1995 · S/N 10079N205DHPhelps Jay R · Somerville, ALBuilt 2009 · S/N 1MK 472CN206ZMVeterans Edge Aviation LLC · Las Vegas, NVBuilt 2018 · S/N 918 AT 912 LSAN208MBramlett David M · Tucson, AZBuilt 2002 · S/N 10021457N20KFMorel Paul F · Locust Grove, GABuilt 2009 · S/N KBS080N2116MHenshaw Calvin T · Clermont, FLBuilt 2000 · S/N 110N211SFYuriy Koziy · Massapequa, NYBuilt 2007 · S/N 07SC062N212EASavage David · N Richlnd Hls, TXBuilt 2023 · S/N VSWX121A0143N212LHRegistration Pending · Wht Sphr Spgs, MTRegistration pendingS/N FCU050N2155AFerguson Darrell W · Acton, MEBuilt 2006 · S/N 1DK408CN215AAFinneyfrock Arthur · Huddleston, VAS/N 14/01N216EBrede Brian K · Lincoln, NEBuilt 2024 · S/N S01912SOHK 0395N216TUTecnam US Inc · Sebring, FLS/N 216/USN221LSWebb Jeffrey J · Fair Play, SCBuilt 2013 · S/N F-13-02-02N221SHSewell David E · Humble, TXBuilt 2023 · S/N 142N221TCSchollmeyer Mike D · Dunn Center, NDBuilt 2007 · S/N 47/2002N221WUtset Anthony · Okeechobee, FLBuilt 2013 · S/N M00982N222SCKathryn E Theiss Phd · Portland, ORBuilt 2007 · S/N 07SC068N222YBCameron Chad E · Box Elder, SDS/N 1LK545CN223PFScout Aerospace LLC · Greensboro, NCBuilt 2019 · S/N 1002 AT 912 LSAN223SThurber Raymond L · White Lake, MIBuilt 2007 · S/N 07SC067N228BMC2s2 Partners LLC · Chesapeake, VABuilt 2023 · S/N 391/USN229DCBowen David W · Tucson, AZBuilt 1996 · S/N 04960707N22ZLDalley Eric · Salt Lake City, UTBuilt 2023 · S/N C0686N23183Nauti Services Inc · West Park, FLBuilt 2006 · S/N UA001N232JWElswick Theodore B · Fernley, NVBuilt 2007 · S/N 07SC044N232PMHangar 23a LLC LLC · Woodbury, MNBuilt 2004 · S/N 3543N2337RHigh Flight Services Inc · Miami, FLS/N UA002N234HWThooft Marlowe · Russell, MNBuilt 2012 · S/N JA262-03-12N234NXRising Wings Aviation Inc · Casper, WYBuilt 2018 · S/N 234/USN236SCHall Richard G · Egg Hbr Twp, NJBuilt 2007 · S/N 07SC078N239AWBrown Daniel J · Grinnell, IABuilt 2008 · S/N SKR 96555N240TUTecnam US Inc · Sebring, FLBuilt 2017 · S/N 240/USN241AVRegistered aircraftBuilt 2022 · S/N AA2A00190SLSAN242TALevy Robert · Staunton, VABuilt 2012 · S/N 068N2430RGreat Lakes Flyer LLC · Waxhaw, NCBuilt 2022 · S/N AC-246N245TASaltair LLC · Salt Lake City, UTBuilt 2014 · S/N 135/USN247MVSpitfire Ventures LLC · San Antonio, TXBuilt 2017 · S/N AC188N2487NMacias Martin V · Yuma, AZBuilt 2007 · S/N A085ULSN2489YKlimenko Eugene · Merrill, WIBuilt 2002 · S/N 0001N248TATumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2015 · S/N 148/USN2491UOddie James W Trustee · Cerritos, CABuilt 2007 · S/N M02XXXSOHK0015N2495XYoder John D · Centreville, MIS/N A083ULSN2497HDuke David O · Arroyo Grande, CABuilt 2006 · S/N T06075N249MSBodrie Sean · Brighton, MIBuilt 2009 · S/N 0807478N24BZTwo Calf Cattle Company LLC · Winifred, MTBuilt 2015 · S/N JA447-03-15N24ESGarris Joel Trustee · Los Angeles, CABuilt 2022 · S/N VSWX1270013N24PVMorris Douglas K · Huntsville, ALBuilt 2005 · S/N 64/13N24XDSummitt Air Corp · Wilmington, DEBuilt 2016 · S/N 703 VSW 912N2519EPrice Donald · Holdenville, OKBuilt 2007 · S/N 112
Back to AD 2012-16-13