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.

N5035KAmberican Aviation Inc · Grand Forks, NDBuilt 1997 · S/N 802-0048 N503FAMccaleb'S Flying Service LLC · Plaucheville, LABuilt 2013 · S/N 802A-0503 N505FAAir Cover Crop Solutions LLC · Frankford, MOBuilt 2013 · S/N 802A-0505 N5066CFarm Ag Enterprises LLC · Buckeye, AZBuilt 1997 · S/N 802A-0045 N506FAPontiac Flying LLC · Pontiac, ILBuilt 2014 · S/N 802A-0572 N508DGOld River Flying Service LLC · Wabash, ARBuilt 2013 · S/N 802A-0499 N5094HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1998 · S/N 802A-0067 N509ZPNeal Aircraft Inc · Slaton, TXBuilt 2021 · S/N 802A-0931 N5110ZPonderosa Airtankers LLC · Safford, AZBuilt 1998 · S/N 802A-0060 N5123UR & D Leasing Inc · Lemoore, CABuilt 1997 · S/N 802A-0053 N512LAWestern Pilot Service Inc · League City, TXBuilt 2009 · S/N 802A-0312 N5144DKeo Ag Service Inc · Keo, ARBuilt 1998 · S/N 802A-0062 N514FAAir Tractor Inc · Olney, TXS/N 802A-1334 N519CKAgwerx Aviation Inc · Yuma, COBuilt 2025 · S/N 802A-1183 N522LAWallin Michael · Walnut Ridge, ARBuilt 2015 · S/N 802A-0622 N522LLRegenald Michaud Aviation LLC · Willows, CABuilt 2013 · S/N 802-0532 N523BFPadgett Ag Rotors LLC · Missoula, MTBuilt 2017 · S/N 802A-0689 N523RBAnderson Interests LLC · East Bernard, TXBuilt 2014 · S/N 802A-0575 N526FAAir Tractor Inc · Olney, TXS/N 802A-1338 N527FRRoma Air Corp · Belle Glade, FLBuilt 2016 · S/N 802A-0681 N528MBPorter Flying Service LLC · Missoula, MTS/N 802A-0350 N530CMPacific Valley Aviation Inc · Arbuckle, CABuilt 2017 · S/N 802A-0680 N535MCMcintyre Flying LLC · Angleton, TXS/N 802A-0526 N554MARkjm LLC · Superior, NEBuilt 2023 · S/N 802A-1011 N557CFH & G Farms Inc · Corcoran, CABuilt 2016 · S/N 802A-0668 N557MAMeyers Aerial Service LLC · Superior, NEBuilt 2025 · S/N 802A-1246 N558LAWilmot Airplane Ventures LLC · Mer Rouge, LABuilt 2024 · S/N 802A-1158 N562LASturdivant Brothers Flying Service Inc · Glendora, MSBuilt 2017 · S/N 802A-0708 N569BHPrecision Air LLC · Dermott, ARBuilt 2024 · S/N 802A-1161 N569LAMoses Lake-Warden Air Service Inc · Moses Lake, WABuilt 2014 · S/N 802A-0569 N573SMMcgarity Flying Service LLC · Sikeston, MOBuilt 2023 · S/N 802A-1078 N5935Ponderosa Airtankers LLC · Safford, AZBuilt 1996 · S/N 802A-0035 N595RSWillmar Aerial Spray Inc · Olivia, MNS/N 802A-1284 N6000JAndy Riddell Flying Service Inc · Marvell, ARBuilt 2010 · S/N 802A-0376 N6002HTumbleweed Leasing LLC · Tacoma, WABuilt 2010 · S/N 802A-0380 N6002TH & C Consulting LLC · Wilmington, DEBuilt 2010 · S/N 802A-0390 N6007SAaa Flying LLC · Tillar, ARS/N 802A-0388 N6011CAero Applications Inc · Burley, IDBuilt 2011 · S/N 802A-0400 N60282American Ag Aviation Inc · Five Points, CABuilt 1995 · S/N 802A-0021 N6050HFarm Ag Enterprises LLC · Buckeye, AZS/N 802A-0011 N608AGBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 802A-0885 N612LAWindsock Skies LLC · Caldwell, TXBuilt 2015 · S/N 802A-0601 N6131KLt Development Group LLC · Watford City, NDBuilt 1995 · S/N 802A-0016 N6136HAurora Cooperative Elevator Company · Aurora, NEBuilt 1995 · S/N 802A-0017 N6148TAllen Air Ltd LLC · Wray, COBuilt 1995 · S/N 802A-0022 N614LAWindsock Skies LLC · Caldwell, TXBuilt 2016 · S/N 802A-0647 N6159FAero Spray Inc DBA · Appleton, MNBuilt 1996 · S/N 802A-0029 N6176YRegistered aircraftBuilt 1996 · S/N 802-0036 N618LAMiles Flying Service Inc · Bono, ARBuilt 2019 · S/N 802-0818 N619LAArg Aviation LLC · Lexa, ARS/N 802-0221

Back to AD 2010-17-18 R1