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.

N357RWWren Rodney K · Hugo, OKBuilt 2013 · S/N KA0706001 N357VAKachemak Bay Flying Service Inc · Temple, TXBuilt 2024 · S/N 401/US N359RBCrenshaw Michael Page · Stayton, ORS/N M3X02-2-00034 N359SMManning Scott G · Clewiston, FLBuilt 2008 · S/N 06051670 N359WBNelson Daniel E · Fairfield, UTS/N 0602322 N361KFWatts Craig W · Incline Village, NVBuilt 2015 · S/N DCS 113 N363XDiscovery Aviation Inc · Discovery Bay, CABuilt 2012 · S/N 070 N3656Amunategui Luis F · Shaker Heights, OHBuilt 2002 · S/N T02044 N366ASAtlantic Aviation International Inc · Lewes, DEBuilt 2025 · S/N DF228 N366HHShaklee Joel B · Brookline, NHBuilt 2008 · S/N S9605-0177 N368LSPazara Timothy D · Channahon, ILBuilt 2006 · S/N 06SC004 N369TPSchley James R · Palmer, AKBuilt 2008 · S/N 0508507 N36TLSzombathy Alkoto J · Pflugerville, TXBuilt 2012 · S/N 000011 N370WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 2022 · S/N 370/US N371JXPress Richard J · San Bernardino, CAS/N 0495583 N3721SSilvan Wayne C · Big Sandy, MTS/N 0995156 N372WSUpdoc Ventures LLC · Clinton, CTBuilt 2024 · S/N 1731 N3739KSobota Mark S · Bethlehem, PABuilt 1998 · S/N 117609987W979 N373USMelbourne Flight Training LLC · Melbourne, FLBuilt 2023 · S/N 373/US N375JRReynolds Jeff · Port Orange, FLBuilt 2007 · S/N 1MK458C N375TSKrips Jack E Jr · Winter Park, FLBuilt 2009 · S/N M3X00-2-00008 N376GSEverythingtonothing Studios LLC · Las Vegas, NVBuilt 2009 · S/N 0707467 N377NXHall Ralph W · Wichita, KSBuilt 2003 · S/N 4404386 N378DTMinor Timothy Stephens · Jefferson, PABuilt 2014 · S/N 7-7135 N37TPParkhurst Thomas G · Guilford, NYFirst renewal noticeS/N ASC-199 N380SSLockheed Martin Aeronautics Co · Lancaster, CABuilt 2006 · S/N 36-800 N3849ALange Daniel M · Whitewater, WIBuilt 1999 · S/N 001 N386USAb Prop Plane I LLC · Metairie, LABuilt 2023 · S/N 386/US N388SGLeinberger Gary · Lancaster, PABuilt 2012 · S/N A237 N389DBBurch David · Grant Township, MIS/N 7710 N390GLSidlinger Computer Corp · Flagstaff, AZBuilt 2009 · S/N 36.833 N3924VParelli Pat · Reddick, FLBuilt 2008 · S/N IPP5-312 N394USWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 394/US N397MTMelbourne Flight Training LLC · Melbourne, FLBuilt 2024 · S/N 397/US N398AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 426/US N398CDBarnes Ralph R · Cocoa, FLBuilt 2007 · S/N UA-007 N398RCChristopherson Rodney V · Williamsburg, MIBuilt 2009 · S/N 06031507 N398UAAb Prop Plane I LLC · Metairie, LABuilt 2023 · S/N 398/US N39RRMesa Airlines Inc · Phoenix, AZBuilt 2022 · S/N VSWX121C0102 N39RWDevecchio Andrew · Santa Fe, NMBuilt 2008 · S/N S9403-0001 N400PZAerotech Aviation LLC · Sidney, OHBuilt 2024 · S/N 4 351 390 D N4010EKitty Hawk Flight School LLC · Kill Devil Hills, NCBuilt 2005 · S/N C-85 N402EDCason Sean R · Bryson, TXS/N CA102871S N402WMoore Brian J · Lancaster, CABuilt 2015 · S/N 0113586 N404KBBrady Kenneth · Santa Fe, TNBuilt 2013 · S/N IPP13-414 N4058UEliasen Anthony J · Carthage, MOBuilt 2006 · S/N A073ULS N405CHGleason William J · Coudersport, PABuilt 2003 · S/N 1269 N406SSCox Tim Ray · Waldron, ARBuilt 2006 · S/N SS05XXXS0HK0506 N409JDStern Robert J · Alpine, WYS/N JAESC0142 N40CPAircam 40cp LLC · Wilmington, DEBuilt 2010 · S/N AC150

Back to AD 2012-16-13