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.

N959GVWings Over Texas Holdings LLC · Denton, TXBuilt 2017 · S/N 232/USN95DYGeng Michael · Dallas, TXBuilt 2008 · S/N DY208/2007N960GVPilot Training Center LLC · Miami, FLBuilt 2017 · S/N 233/USN961GVAviation Financial Corp · Torrance, CABuilt 2017 · S/N 235/USN963DDSeapike Aviation LLC · Beaufort, SCBuilt 2015 · S/N 127N964GVConeburripul Corp · Miami, FLBuilt 2017 · S/N 239/USN964SSSmith Craig W · Horton, MIBuilt 2003 · S/N 01011404SN965GVMoretti Luigi U Ricci · Swarthmore, PAS/N 242/USN966GVWings Over Texas Holdings LLC · Denton, TXBuilt 2018 · S/N 243/USN967GVWings Over Texas Holdings LLC · Denton, TXBuilt 2018 · S/N 244/USN968GVMarsh Equipment LLC · Aurora, ORBuilt 2018 · S/N 247/USN968ZMRoss Roofing And Construction Inc · Marina, CABuilt 2025 · S/N VSWX121A0189N969GVAkyna Medical Management LLC · Sacramento, CABuilt 2018 · S/N 248/USN969RCAllegro Aircraft Alliance LLC · American Fork, UTBuilt 2007 · S/N 07-240N96WRMelero Ivan V · San Francisco, CABuilt 2006 · S/N 19APXN971GVWings Over Texas Holdings LLC · Denton, TXBuilt 2018 · S/N 251/USN972GVWings Over Texas Holdings LLC · Denton, TXBuilt 2018 · S/N 252/USN973GVN973gv LLC A Series Of Aero Lease LLC · San Antonio, TXBuilt 2018 · S/N 253/USN975GVOrlando Flight Academy Inc · Apopka, FLBuilt 2018 · S/N 254/USN975JMMolinski John F · Mccall, IDBuilt 2012 · S/N 7-7061N976GVMarsh Equipment LLC · Aurora, ORBuilt 2018 · S/N 259/USN977GVFp Aircraft Holdings LLC · Alvord, TXBuilt 2018 · S/N 260/USN978GVChucktown Flight Training LLC DBA · Summerville, SCBuilt 2018 · S/N 264/USN980GVWings Over Texas Holdings LLC · Denton, TXBuilt 2018 · S/N 267/USN984AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 428/USN986ESKathron Aviation Services LLC · Montezuma, NCBuilt 2006 · S/N 989N987EDBurch Kyle R · Overgaard, AZS/N 06041581N987SJacobs Brian · Aptos, CABuilt 2013 · S/N 0998255N98RWWillmore Roderick J · Saint Anthony, IDBuilt 2020 · S/N KA 19012436N992DNTestory Perry E · Urbana, ILBuilt 2003 · S/N 06001378N9957SKrantz Henry C III · Pittsburg, KSBuilt 2006 · S/N A-071-ULSN995ADSmith Norton R · Lihue, HIBuilt 2011 · S/N AC154N998GRGillam Willard C · Grand Junction, COBuilt 2025 · S/N 75-12078N999PFFlying Foxes LLC · Sheridan, WYBuilt 2007 · S/N 01071795N999UEHartman Sean W · Franklin, ILBuilt 2006 · S/N 057.05N999YWHuckins George James Jr · Live Oak, TXBuilt 2009 · S/N 7-7000N99YRReif Corp LLC · Mesquite, NVS/N PC04079W301
Back to AD 2012-16-13