Registered aircraft · 1,951

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:2023-17-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:2023-17-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:2023-17-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:2023-17-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:2023-17-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:2023-17-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.

N1001KHorus LLC · Omaha, NEBuilt 2017 · S/N F-16-07-01 N100BTSnowbird Aviation Corp · Signal Mountain, TNBuilt 2024 · S/N 12177 N100DTTurner Daniel H · Sparks, NVBuilt 2019 · S/N 0303 N1014Aeon62 Holdings LLC · Plano, TXBuilt 2025 · S/N 12186 N1018GSale Reported · Scandia, KSSale reported, canceledBuilt 1996 · S/N 03960691 N101LWCossaviationtx LLC · Canyon Lake, TXBuilt 2016 · S/N 231/2016 N1022YBurnette Harry · Sharpsburg, GABuilt 2022 · S/N 12127 N102BACacciarelli Anthony G · Tiverton, RIBuilt 2018 · S/N 00057 N102DFLe Garrett P · Exeter, CAS/N 10029 N102TGAvocation Aviation LLC · Findlay, OHS/N CAK04171S N102USAb Prop Plane I LLC · Metairie, LABuilt 2024 · S/N 1120/US N103ESouthtec Inc · Wilmington, DEBuilt 2006 · S/N 0106424 N1044AAtlas Aviation Tampa Inc · Tampa, FLBuilt 2025 · S/N 12202 N104AJPosav Holdings LLC · Zephyrhills, FLBuilt 2025 · S/N G-1015 N104YRichter-Sand Robert J · Albuquerque, NMBuilt 2017 · S/N KA11316217 N105BPCassens Eric · Coopersville, MIS/N 531 N1067AWilson Kevin W · Naples, FLBuilt 2022 · S/N 272K N106PVJensen Douglas R · Mesa, AZBuilt 2014 · S/N JA378-05-14 N106SEPotter Julianne M · Rimrock, AZBuilt 2007 · S/N T07009 N1078Sentinel Air LLC · Walterboro, SCBuilt 2004 · S/N CNS 026 N107ERAguila Rosario Jimmy A · Carolina, PRBuilt 2005 · S/N SKR0501558 N107HJLott John R · Andersonville, GABuilt 2015 · S/N ASC-201 N107PGGoodman James A · Highland Park, ILBuilt 2005 · S/N C95070118 N107TFMclaughlin Shawn · Port Ludlow, WABuilt 2020 · S/N 121142 N1080Skram Airlines LLC · Wurtsboro, NYBuilt 2013 · S/N 1LK579C N108CAWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 1115/US N10DMThree Two Romeo LLC · Lewes, DEBuilt 2019 · S/N 121069 N10ZGReeves Air Glide LLC · Moriarty, NMBuilt 2009 · S/N 300 V 912 N111BTPestana Joseph P · Langlois, ORBuilt 2004 · S/N 084/2004 N111BYKjs Capital LLC · Bonita Springs, FLBuilt 2024 · S/N 20232235 N111FACharrier Michael J · Hessmer, LAS/N 6000 N111LYWatkins Jonathan Trustee · Florence, ORBuilt 2008 · S/N AC142 N111VVAscension Aviation Of Florida LLC · Bonita Springs, FLBuilt 2024 · S/N 20242240 N111WTAscension Aviation Of Florida LLC · Bonita Springs, FLBuilt 2024 · S/N 20242239 N1121ERuscito Joseph · Boise, IDBuilt 2019 · S/N KA18333388 N112ETTrue Eddie M · Yelm, WABuilt 2007 · S/N CAI02771S N112GSale Reported · SigmaringenSale reportedBuilt 2000 · S/N 37 N112WBBrecheisen Adell W II · Cedar Falls, IABuilt 2021 · S/N 120887 N113CGTreeline Inc · Lincoln, MEBuilt 2003 · S/N 2000 N113RSBlades Over Me LLC · Vero Beach, FLBuilt 2020 · S/N 071 N114KHProvo Harold · Westlake Village, CABuilt 2019 · S/N 121123 N114MA & F Aviation Services LLC · Collierville, TNBuilt 2024 · S/N 12174 N1152RDuane Robert J · Colonia, NJBuilt 2019 · S/N 0039 N1152SSalisbury Patrick J Trustee · Eugene, ORBuilt 2019 · S/N 121052 N115BGBoyd Geoffrey M · Dallas, TXBuilt 2022 · S/N 001 N115HTSpringthorpe Dwight II · Wake Forest, NCBuilt 2023 · S/N 121349 N115KBFly Away Inc · Lackawanna, NYBuilt 2014 · S/N 1LK588C N1162PDrumheller Enterprises Inc · Kirkwood, PABuilt 2001 · S/N AP2L0001 N116BADiamantina Blue LLC · Schenectady, NYBuilt 2018 · S/N 00059 N116CAWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 1116/US

Back to AD 2023-17-13