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.

N780FAMd Aircraft Leasing LLC · Ripon, WIBuilt 2019 · S/N 802A-0807 N780NAAir Tractor Inc · Olney, TXS/N 802A-1333 N781FAAgwings Equipment LLC · Jonesboro, ARBuilt 2020 · S/N 802A-0860 N782APTumbleweed Leasing LLC · Tacoma, WABuilt 2019 · S/N 802A-0782 N782FAAerial Applicators Of Missouri LLC · Jonesboro, ARBuilt 2021 · S/N 802A-0920 N783ASAero Spray Inc DBA · Appleton, MNBuilt 2016 · S/N 802A-0651 N783FABi-State Air Inc · Veedersburg, INS/N 802A-0992 N788LADungan Aerial Service Inc · Falmouth, INBuilt 2019 · S/N 802A-0788 N795LAWilmot Airplane Rentals LLC · Dover, DEBuilt 2023 · S/N 802A-1007 N79BMAgrijet Inc · Ontario, ORBuilt 2008 · S/N 802A-0287 N8007XBaylee Company Inc · Bear, DEBuilt 2020 · S/N 802A-0869 N800FVFolden Aviation Inc · Weiner, ARBuilt 2025 · S/N 802-1197 N800LAAkbj LLC · Lewes, DEBuilt 2019 · S/N 802A-0800 N800NCState Of North Carolina · Raleigh, NCBuilt 2016 · S/N 802-0671 N800NZAir Tractor Inc · Olney, TXS/N 802A-1323 N8010ML3harris Technologies Flight Capital LLC · Greenville, TXS/N 802-4057 N8011NH&M Flying Service LLC · Osceola, ARS/N 802A-0638 N8015UL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 802-4031 N80166Aero Spray Inc DBA · Appleton, MNBuilt 2017 · S/N 802A-0685 N8016BCoppage Farm Services Inc · Braggadocio, MOFirst renewal noticeBuilt 2016 · S/N 802A-0660 N801FFSpring Creek Aviation LLC · Brinson, GAS/N 802A-0333 N801HBKansas Farm And Ranch Inc · Seneca, KSBuilt 2014 · S/N 802A-0539 N801HFHutcherson Flying Inc · Forrest City, ARBuilt 2021 · S/N 802A-0923 N801NCState Of North Carolina · Raleigh, NCBuilt 2017 · S/N 802A-0724 N801NZFour Elements Aviation LLC · Lewes, DEBuilt 2020 · S/N 802A-0829 N801RWAerial Applicators Of Missouri LLC · Qulin, MOBuilt 2019 · S/N 802A-0792 N8024URegistered aircraftBuilt 2022 · S/N 802A-0972 N8027QT & M Aircraft LLC · Monticello, ILS/N 802A-0666 N80292Kroeplin Air LLC · Highmore, SDBuilt 2022 · S/N 802A-0951 N80293Visser Ag Inc · Rigby, IDBuilt 2017 · S/N 802A-0720 N802ACAurora Cooperative Elevator Co · Aurora, NEBuilt 2020 · S/N 802A-0834 N802AHRanch Aero LLC · Sterling City, TXBuilt 2023 · S/N 802A-1014 N802AJAgri Jet Inc · Aberdeen, IDBuilt 2023 · S/N 802A-1041 N802AMFinke Aviation LLC · Charleston, MSBuilt 2014 · S/N 802-0540 N802APAg Air Care Inc · Wilmington, DEBuilt 2021 · S/N 802A-0890 N802AZRiceland Aviation Inc · Jennings, LABuilt 2016 · S/N 802A-0646 N802BBBell Flying Inc · Newport, ARBuilt 2025 · S/N 802A-1257 N802BFBlue Sky Management LLC · Washington, IAS/N 802A-0116 N802BHMoes Crop Dusting Service Inc · Marysville, CABuilt 2019 · S/N 802-0797 N802BKKlein Flying Service Inc · Lawrenceville, ILBuilt 2021 · S/N 802A-0892 N802BLLindeman Inc · Dhanis, TXBuilt 1994 · S/N 802A-0010 N802BMEvergreen Flying Service Inc · Rayville, LABuilt 2005 · S/N 802A-0216 N802BRAir Kraft Spraying Inc · Timber Lake, SDBuilt 2004 · S/N 802A-0171 N802BWBoedeker Flying Service West LLC · Childress, TXBuilt 2022 · S/N 802A-0939 N802CBR & W Flying Inc · Paragould, ARBuilt 2022 · S/N 802A-0962 N802CEArtic One LLC · Fairbanks, AKBuilt 2012 · S/N 802-0467 N802CGGb Aerial Applications Inc · Slaton, TXBuilt 2016 · S/N 802A-0675 N802CLKansas Farm And Ranch Inc · Seneca, KSBuilt 2017 · S/N 802A-0682 N802CRMeyer Bros Ag LLC DBA · Algona, IABuilt 2018 · S/N 802A-0772 N802CWAurora Cooperative Elevator Company · Aurora, NEBuilt 2000 · S/N 802A-0103

Back to AD 2010-17-18 R1