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.

N146CDStevens Mike · Duluth, MNS/N 014-068 N146EPLenz Christian J · Allen, TXBuilt 2023 · S/N VSWX121A0146 N146UAFoale Aerospace Inc · Houston, TXBuilt 2008 · S/N 102/13 N148SRTansky Stanley S · Logan, OHBuilt 2010 · S/N IDK395C N152GHatfield Keith A · Dallas, TXBuilt 2012 · S/N 000588 N152WPCook Christopher M · Twin Falls, IDS/N 04-285 N153WPFlamingo Aviation LLC · Bend, ORBuilt 2006 · S/N 04-286 N154RMurphys Auto Gyro Sales LLC · Dade City, FLBuilt 2020 · S/N 0044 N15629Williams Donald B · Wingate, NCBuilt 1994 · S/N 0693111 N156TXDucote Kendall J · Prairieville, LABuilt 2008 · S/N PC120791P504 N156WSDryden Everett R · Wolcott, VTBuilt 1999 · S/N 1190-0399-7-W993 N161RNWaterwings Seaplanes LLC · Hoover, ALBuilt 2005 · S/N AC061 N164XStetson Jeffry W · East Lansing, MIFirst renewal noticeBuilt 2005 · S/N 200164 N166KWalker Troy L · Greenville, ILBuilt 2008 · S/N 0707468 N1672LPike Phillip M · Saint Petersburg, FLFirst renewal noticeBuilt 2000 · S/N 7617 N167TUHawkins Flight Academy LLC · Shelbyville, TNS/N 167/US N1682WDavis Chad A · Luana, IABuilt 2004 · S/N 1100088 N168MBNemec David M · Helendale, CABuilt 2007 · S/N 125-07-02 N16BAOwen Aviation Co LLC · Meridian, MSBuilt 2020 · S/N 16202693 N170TUMichigan Department Of Natural Resources · Roscommon, MIBuilt 2016 · S/N 170/US N172LMBristol Todd J · Mesa, AZBuilt 2009 · S/N F-09-08-05 N173LMCopper City Aviation Services LLC · Bisbee, AZBuilt 2009 · S/N F-09-08-06 N174LMRasmussen Gregory · Floyds Knobs, INBuilt 2009 · S/N F-09-08-07 N1773CZollinger Duane C · Rittman, OHBuilt 2007 · S/N 05061742 N177AXXim LLC · Columbia, MOBuilt 2010 · S/N 200.177 N178ABDawson Daniel D · Princeton, IABuilt 2009 · S/N 01061720-ES N17KLWiers Keith R · Saint Albans, MEBuilt 2004 · S/N SKR0207204 N181ARGodbout Raymond J · Gorham, NHBuilt 2026 · S/N 181 N181QKoerner Michael S · Rch Palos Vrd, CABuilt 2004 · S/N 04-04-05 N1826RHolsinger Kent H · Denver, COBuilt 2011 · S/N 1826 N185TUAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2017 · S/N 185/US N187KCSampson Air Services LLC · Queen Creek, AZBuilt 2012 · S/N AC167 N188RRStemen Randy · Canal Winchester, OHBuilt 1993 · S/N 0791107 N190GMMahon Gary · Winslow, ILBuilt 2015 · S/N 7269 N1914WSmitherman Roger · Choudrant, LAS/N 2000 N192TUIasco Flight Training Inc · Redding, CABuilt 2017 · S/N 192/US N1935CCarmean Todd R · Owasso, OKBuilt 2013 · S/N F-12-07-04 N194ABBriese Ronald R · Brandon, WIBuilt 2001 · S/N SKR0112154 N1950SLammers Robert K · Oostburg, WIS/N A096ULS N195EARegistration Pending · Orem, UTRegistration pendingBuilt 2023 · S/N VSWX121A0140 N1969GTucker Patrick A · Hopkinsville, KYBuilt 2004 · S/N 679 N1981BBurkhardt David A · Oregon City, ORBuilt 2012 · S/N 159 N199TUTwin Icarus LLC · Mount Juliet, TNBuilt 2017 · S/N 199/US N19VMRegistration Pending · Colorado Springs, CORegistration pendingBuilt 2007 · S/N 07SCO28 N1BASeawings LLC · Saint Petersburg, FLBuilt 2021 · S/N 00140 N2006KHelicorp Mro LLC · Dover, DEBuilt 2025 · S/N 421/US N2018Experimental Aircraft Assn Inc · Oshkosh, WIBuilt 2018 · S/N 121100 N202XSDurney Alan Nelson · Santa Clarita, CABuilt 2023 · S/N C0687 N20386Burlingame Ralph H Jr · Mound, MNBuilt 2003 · S/N KB01-3-00007 N204PHHartunian Robert T · Fawnskin, CABuilt 2025 · S/N 535

Back to AD 2012-16-13