Registered aircraft · 686

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:2010-17-18-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-17-18-R1') 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:2010-17-18-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-17-18-R1')
  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:2010-17-18-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-17-18-R1')
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.

N816QAOver The Top Aviation Inc · Jonesboro, ARBuilt 2016 · S/N 802A-0672 N816SAStott Aerial Spray Inc · Jefferson, IABuilt 2023 · S/N 802A-1021 N817HBoedeker Flying Service East LLC · Childress, TXBuilt 2016 · S/N 802A-0674 N817RXHog Air Aviation Inc · Paragould, ARBuilt 2025 · S/N 802A-1234 N818AJC & C Flying Service Inc · Pocahontas, ARBuilt 2017 · S/N 802A-0714 N818ASAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1319 N818EBBretts Spray Service Inc · Onida, SDFirst renewal noticeBuilt 2017 · S/N 802A-0715 N818SASak I LLC · Miller, SDBuilt 2020 · S/N 802A-0842 N819ACAurora Cooperative Elevator Co · Aurora, NEBuilt 2023 · S/N 802-1030 N822KANeal Aircraft Inc · Slaton, TXBuilt 2014 · S/N 802A-0555 N822TAN822ta LLC · Kinsley, KSBuilt 2021 · S/N 802A-0894 N825DAAero Spray Inc DBA · Appleton, MNBuilt 2018 · S/N 802A-0737 N828CGG B Aerial Applications Inc · Slaton, TXS/N 802A-1282 N828GBG B Aerial Applications Inc · Slaton, TXBuilt 1997 · S/N 802A0052 N829JWBank Of Utah Trustee · Salt Lake City, UTS/N 802A-1283 N829RTMcclendon Services LLC · Marianna, ARBuilt 2023 · S/N 802A-1010 N830DAAero Spray Inc DBA · Appleton, MNBuilt 2022 · S/N 802A-0930 N830WPWestern Pilot Service Inc · League City, TXBuilt 2021 · S/N 802A-0886 N831DAAero Spray Inc DBA · Appleton, MNBuilt 2022 · S/N 802A-0940 N831LAAero Leasing LLC · Virden, ILBuilt 2023 · S/N 802A-1031 N835ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 802A-0887 N839FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2023 · S/N 802A-1042 N83WFAeronautical Technologies Inc · Clovis, NMBuilt 2023 · S/N 802A-1023 N841BFWells Flying Services LLC · Holdrege, NEBuilt 2020 · S/N 802A-0821 N841NFNew Frontier Aviation LLC · Fort Benton, MTBuilt 2025 · S/N 802A-1178 N842HAkbj LLC · Lewes, DEBuilt 2021 · S/N 802A-0872 N842KAKh Aviation LLC · Langdon, NDBuilt 2015 · S/N 802A-0599 N842NFAir Tractor Inc · Olney, TXS/N 802A-1332 N846DAAero Spray Inc DBA · Appleton, MNBuilt 2020 · S/N 802A-0846 N847FAAerial Crop Services LLC · East Prairie, MOBuilt 2020 · S/N 802-0847 N848HAAerial Applicators Of Missouri LLC · Qulin, MOBuilt 2020 · S/N 802A-0868 N8502HPope James D · Lewiston, IDS/N 802-0140 N8503WPioneer Agviation 2 LLC · Holdrege, NES/N 802A-0134 N8504RRussell Armstrong And Danny Hawk DBA · Yuba City, CABuilt 2001 · S/N 802A-0123 N8504TWakefield Aircraft LLC · Cooperstown, NDBuilt 2005 · S/N 802A-0218 N8505EVisser Ag Inc · Rigby, IDFirst renewal noticeS/N 802A-0133 N8507KA & M Flying Service Inc · Carlise, ARBuilt 2001 · S/N 802A-0122 N8507NTumbleweed Leasing LLC · Tacoma, WABuilt 2003 · S/N 802A-0158 N8509SAir Tractor Inc · Olney, TXBuilt 2003 · S/N 802A-0164 N8509TCrop Jet Aviation LLC · Gooding, IDS/N 802A-0152 N8512FR & D Leasing Inc · Lemoore, CAS/N 802A-0215 N8512LAdvance Flight Training & Leasing LLC · South Saint Paul, MNBuilt 2004 · S/N 802-0170 N8513QTri-Air Farms LLC · Mamou, LABuilt 2002 · S/N 802-0127 N8513VSyf LLC · Okmulgee, OKS/N 802-0128 N851BFF & M Flying Service LLC · Columbus, MSBuilt 2022 · S/N 802A-0996 N851CHCkw Aviation LLC · Dalhart, TXBuilt 2024 · S/N 802A-1170 N851DCKansas Farm & Ranch Inc · Seneca, KSBuilt 2021 · S/N 802A-0921 N8520ZSyf LLC · Okmulgee, OKBuilt 2004 · S/N 802-0184 N8521WA & M Flying Service Inc · Carlisle, ARBuilt 2004 · S/N 802A-0167 N8522SDodson International Parts Inc · Rantoul, KSBuilt 2003 · S/N 802A-0161

Back to AD 2010-17-18 R1