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.

N304WSMaberry Buell G · Pierre, SDS/N 007 LSA N30628Zollinger Rudolph A · Rittman, OHBuilt 1999 · S/N 001 N307DNRegistration Pending · Scottsdale, AZRegistration pendingS/N 07SC056 N30ALLink Alden · Milton, NYBuilt 2007 · S/N 73735 N311DZSawaf Darius · Dallas, TXBuilt 2007 · S/N 243 N31311Mcclure Jared B · Claremore, OKBuilt 2007 · S/N D99912SOHK0356 N313CMTray Jason R · Juneau, WIBuilt 2017 · S/N T&S J28117S N31408Adams John P · Rosebud, MOBuilt 2006 · S/N A082ULF N3143MSmile Machine LLC · Auburn, WABuilt 2007 · S/N 002 N3143SStafford Marlin C · Patterson, GABuilt 2024 · S/N JA697-6-23 N314BJClayton Smith · Green River, WYFirst renewal noticeBuilt 2014 · S/N C0111-0271 N31718Ohlrich Greg · Mount Dora, FLBuilt 2007 · S/N 0902031 N3173PHalberg Bill R · Battle Ground, WABuilt 2005 · S/N HD04130XC N31750Yeats Chris P · Collinsville, OKS/N 001 N31788Falcontrust Holdings LLC · Pinecrest, FLBuilt 2007 · S/N UA004 N317GWWings Over Texas Holdings LLC · Denton, TXBuilt 2026 · S/N 442/US N31EEJudd Tharon · Orem, UTBuilt 2019 · S/N AC-215 N3200VKnight Brent · Moundridge, KSBuilt 2010 · S/N IPP-10-393 N321CAGarratt Carol Ann · Moriarty, NMBuilt 2006 · S/N 0504372 N329PTPilot Training Center LLC · Miami, FLBuilt 2017 · S/N 237/US N330BLCentral Seaplanes LLC · Cleveland, OKBuilt 2022 · S/N 148 N330VAN330va LLC · Plymouth, MIBuilt 2022 · S/N 348/US N33223Clayton Randall L · Mapleton, UTBuilt 2003 · S/N A 139 PEG N334CTAngel LLC · Missoula, MTBuilt 2006 · S/N 06-07-17 N3372Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 2022 · S/N 1083 SFNM 912 LSA N337SELee Mark J · Arlington, WABuilt 2023 · S/N 120970 N339ZSSeitzer Dale · Roseville, MNBuilt 2025 · S/N 2401039 N33EPWilliams Jeffrey D · Florence, ALBuilt 2004 · S/N 0103333-S N341JAToga LLC · Cumming, GABuilt 2015 · S/N JA341-01-14 N341JDRegistration Pending · Monroe, LARegistration pendingS/N 08-11-51-788 N342MFCommander Aircraft Services Inc · West Palm Beach, FLBuilt 2014 · S/N JA317-09-13 N342USUrva Aviation USA Corp · Pompano Beach, FLBuilt 2021 · S/N 342/US N344EADelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2024 · S/N VSWX121A0168 N345HLLohmeyer Wayne D · Katy, TXBuilt 2022 · S/N M01964 N345KFKfa Aircraft USA Inc · Lewes, DEBuilt 2025 · S/N 023-D-23 EXUL N3470SRicketts Michael D · Weirsdale, FLBuilt 2009 · S/N 842 N347MBWilliams Michael David · Paducah, KYS/N 008LSA N349DNNorman Dave · Los Gatos, CABuilt 2007 · S/N 001 N34WFJohnston Aviation LLC · Melbourne Beach, FLBuilt 2022 · S/N 1106 SWN 80 LSA N3503Registration Pending · Oxnard, CARegistration pendingBuilt 2005 · S/N 001 N3503FYarbro Bruce Edwin · Poplar Bluff, MOBuilt 2006 · S/N 000710 N3505DMeyer Bruce V · Largo, FLBuilt 2000 · S/N A091055 N3506LHinsz Cory · Spokane, WABuilt 2006 · S/N T06002 N3512SJensen Brian S · Pahrump, NVBuilt 2007 · S/N KL359A N352RRKindred Douglas Wayne · Kennesaw, GAS/N VSWX1210099 N353FMelbourne Flight Training LLC · Melbourne, FLBuilt 2022 · S/N 353/US N355NLLong Nicholas · Woodinville, WABuilt 1997 · S/N 10286 N355USMelbourne Flight Training LLC · Melbourne, FLBuilt 2022 · S/N 355/US N356TNAukee Isaac · Ironwood, MIS/N 1DK176 N357PCFisher James C Jr · Calhoun, GABuilt 2019 · S/N DH106

Back to AD 2012-16-13