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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N459AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 427/US N45VJBolkan Christopher L · Pasco, WABuilt 2006 · S/N 1205 N460HJDaniell William · Miami, FLBuilt 2017 · S/N A238 N4610Pfisters Helicopters Inc · Pasco, WABuilt 2007 · S/N 235 V 9120607 KIT 49 N4611TFranks Eric E · Jamestown, TNFirst renewal noticeBuilt 2000 · S/N 62/2000 N466SKKurtz Steven R · Fort Gibson, OKBuilt 2022 · S/N 03190043 N482LPGruen Richard A · Bethany Beach, DEBuilt 2023 · S/N VSWX121A0134 N4851AGirard Louis W · Schulenburg, TXBuilt 2002 · S/N 4676 N485GWWings Over Texas Holdings LLC · Denton, TXBuilt 2026 · S/N 434/US N486RUBarney David A · Wabash, INBuilt 2007 · S/N S06XXXSOHK0515 N487WMarcus Gregory · Valencia, CABuilt 2019 · S/N 987 SWN 100 IS N4880WWorden Robert S · Okoboji, IABuilt 2009 · S/N A062 N488AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 423/US N48FPLookout Mountain Flight Park · Rising Fawn, GABuilt 2003 · S/N 069 N4902PGeisen Ernest F · Cullman, ALBuilt 1997 · S/N 79-91212942428 N492VPLite Flight Powered Parachutes LLC · Little Falls, MNBuilt 2025 · S/N A457ULS N4944KEaa Chapter 24 · Oklahoma City, OKBuilt 2006 · S/N 10051702 N4959Wyckoff David T · Pittsburg, KSBuilt 2007 · S/N 780 N495SSSchuler Wanda S Trustee · Red Bluff, CAS/N 12-09-54-207 N496LPFly Rybo LLC · Helena, MTBuilt 2023 · S/N 1132 AT 912 LSA N499RDGillen John C · Delta, OHBuilt 2021 · S/N 200 N49DJTanaka Wesley N · Grantsburg, WIBuilt 2007 · S/N DK415C N5024JBoone Dennis W · Columbia, ALBuilt 2005 · S/N 05-215 N502CWZimmerman J Earl · Elizabethtown, PABuilt 2007 · S/N 08051681 N502LPRegistered aircraftBuilt 2023 · S/N 1195 AT 912 LSA N5052JSherman Douglas R · Tecumseh, MIBuilt 2006 · S/N A074ULS N5060SNelson Doug K · Fort Atkinson, WIBuilt 2006 · S/N XT-912-117 N5086YKeller Douglas W · Pittsboro, INBuilt 2007 · S/N 09041615 N509FMMcpherson Craig · Blum, TXBuilt 2022 · S/N M01962 N50FPLuzuriaga Pedro · Grapevine, TXBuilt 2003 · S/N 068 N510SCEaa Aviation Foundation Inc · Oshkosh, WIS/N 10-51 N51247Hougen Nathaniel J · Union, IAS/N SKR0204185 N512LJAmerican Porch LLC · Townsend, MTBuilt 2007 · S/N JAESC 0047 N513AKWolf W Brad · Pensacola, FLBuilt 2007 · S/N 07061755 N5149FMcmurray David L · Orlando, FLBuilt 2005 · S/N 1078 N514GMSlining Mark D · Dows, IABuilt 2014 · S/N 0455 N514RWWilson Robert J · El Monte, CABuilt 2008 · S/N TX-002 N514TMLampman Jordan R · Fairmont, MNBuilt 2006 · S/N 61911 N519ZHJr Aviation LLC · Gautier, MSBuilt 2014 · S/N 07-2014 N520DWWitham Darrell J · Croswell, MIBuilt 2006 · S/N 06-07-14 N520SARempel Abram · Columbus, NMS/N R3-0US-0003 N520TGGlenn Timothy C · Heber City, UTBuilt 2021 · S/N 121041 N521FJHch Aviation Holdings LLC - Series N521fj · Nacogdoches, TXBuilt 2023 · S/N 1057/US N521RWMarkle James E · Calimesa, CAS/N 07030977 N522FJHch Aviation Holdings LLC - A Series Of · Nacogdoches, TXBuilt 2023 · S/N 1058/US N524ABFeliz Thaisio D · Port Saint Lucie, FLBuilt 2006 · S/N 220 N525ABBrown Joshua · Greenwood, INBuilt 2006 · S/N 06-10-04 N525FJHch Aviation Holdings LLC · Nacogdoches, TXBuilt 2024 · S/N 1098/US N526BEHosto Robert M · La Moille, ILBuilt 2013 · S/N A129 N528AJPayne Adam · Blairsville, GABuilt 2025 · S/N JA613-01-21

Back to AD 2012-16-13