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.

N3086AArrow Aviation Inc · Broken Bow, NEBuilt 2015 · S/N 802A-0616 N309PFPalmer Flying Service Inc · Manito, ILBuilt 2025 · S/N 802A-1213 N313FAAg Air Flying Service Inc · Toppenish, WABuilt 2016 · S/N 802A-0655 N316LAAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1316 N324BSB&S Air Inc · Lumpkin, GABuilt 2025 · S/N 802A-1189 N325BMFarm Air Service Inc · Tallulah, LABuilt 2003 · S/N 802A-0144 N329LAWells Flying Services LLC · Holdrege, NES/N 802A-0345 N332ATAg Solutions LLC · Satanta, KSBuilt 1999 · S/N 802A-0087 N332BSHog Air Aviation Inc · Paragould, ARBuilt 2019 · S/N 802A-0791 N333BRB&R Aerial Crop Care Inc · Connell, WABuilt 2022 · S/N 802A-0989 N334BSMitchell Andrew D Trustee · Winnie, TXS/N 802A-0521 N335BSOld River Flying Service LLC · Helena, ARBuilt 2016 · S/N 802A-0643 N335LAAir Tractor Inc · Olney, TXS/N 802-1335 N335QFBearcreek Flying Service LLC · Oakes, NDBuilt 2013 · S/N 802A-0522 N339BSB & S Air Inc · Lumpkin, GABuilt 2020 · S/N 802A-0839 N340LATri-Air Farms LLC · Mamou, LABuilt 2009 · S/N 802A-0349 N344VAAir Tractor Inc · Olney, TXS/N 802A-1344 N347BMAir Tractor Inc · Olney, TXS/N 802A-1347 N347ERO'Briens Flying Service Inc · Iowa, LABuilt 2022 · S/N 802A-0944 N347REAir Tractor Inc · Olney, TXS/N 802A-1331 N349ASAero Applicators Inc · Sterling, COBuilt 2015 · S/N 802A-0603 N350DAAir Tractor Inc · Olney, TXS/N 802A-1354 N354FSAnderson Interests LLC · East Bernard, TXBuilt 2010 · S/N 802A-0355 N358ASNew Frontier Aviation LLC · Fort Benton, MTBuilt 2015 · S/N 802A-0604 N363ATAeronautical Technologies Inc · Clovis, NMBuilt 2013 · S/N 802A-0508 N363GSParrish Aerial Services LLC · Wilmington, DEBuilt 2015 · S/N 802-0587 N365LAFarm Air Corp · Minturn, ARBuilt 2010 · S/N 802A-0365 N369ZPRegistration Pending · Pasco, WARegistration pendingBuilt 2025 · S/N 802A-1253 N370JBAurora Cooperative Elevator Co · Aurora, NEBuilt 2011 · S/N 802A-0399 N376ASAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0607 N379ASAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0609 N385LABrunetti Finley Jr · Shelby, MSBuilt 2010 · S/N 802A-0385 N386LAHinkle Airspray Inc · Cavalier, NDBuilt 2010 · S/N 802A-0386 N389LABailey Air LLC · Delhi, LABuilt 2010 · S/N 802A-0389 N392KWSpradin Flying Service Inc · Petersburg, TXBuilt 2007 · S/N 802A-0282 N393LAC&L Holzwarth Inc · Virden, ILBuilt 2024 · S/N 802A-1093 N396LANeal Aircraft Inc · Slaton, TXS/N 802A-0331 N397LAWil-Co Flying Service LLC · Dewitt, ARBuilt 2009 · S/N 802A-0332 N398ASAero Spray Inc DBA · Appleton, MNBuilt 2014 · S/N 802A-0564 N398LAWestern Pilot Service Inc · League City, TXBuilt 2007 · S/N 802A-0263 N406BMEvergreen Flying Service Inc · Rayville, LABuilt 2007 · S/N 802-0265 N40LAMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 802A-0182 N4106AAir Cover Crop Solutions LLC · Frankford, MOBuilt 2005 · S/N 802A-0223 N41119Crop Jet Aviation LLC · Gooding, IDS/N 802A-0229 N4120RTumbleweed Leasing LLC · Tacoma, WAS/N 802A-0232 N4122XEllis Flying Service Inc · Newport, ARBuilt 2017 · S/N 802A-0692 N4149PPonderosa Airtankers LLC · Safford, AZBuilt 2007 · S/N 802A-0255 N41525County Line Flying Service Inc · Coy, ARS/N 802A-0231 N41613All In Flying Co · Wilmington, DEBuilt 2008 · S/N 802A-0273 N41647Odessa Air Service Inc · Moses Lake, WABuilt 2007 · S/N 802A-0279

Back to AD 2010-17-18 R1