Skip to content

Aero Commander S2R

Registered aircraft · 60

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('0143022')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('0143022')
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.

N1662SSlater Richard J · Maddock, NDBuilt 1973 · S/N 1835R N1746SWilde Air Service LLC · Volga, SDBuilt 1968 · S/N 1446R N1747SArnt Aerial Sprying Inc · Worthington, MNBuilt 1968 · S/N 1447R N3063QPrecision Ag Air LLC · Pendleton, INBuilt 1971 · S/N 1560R N331JNMagnum Aviation LLC · Goff, KSBuilt 1968 · S/N 1451R N3662XBellamy Mark A · Freeville, NYBuilt 1974 · S/N 1890R N3663XPietron Spraying Inc · Larimore, NDBuilt 1974 · S/N 1891R N3669XHofer Perry L · Doland, SDBuilt 1974 · S/N 1893R N3695XSides Aviation LLC · Cambridge, NES/N 1910R N504RGGustin Aviation · Lewiston, IDBuilt 1972 · S/N 1634R N510SSPrecision Ag Air LLC · Pendleton, INBuilt 1972 · S/N 1635R N51AROlsem Aerial Application Services LLC · Westbrook, MNBuilt 1970 · S/N 1523R N5508XBoeing Co · Renton, WABuilt 1973 · S/N 1708R N5510XVanderpool Gary W · Alamo, TXBuilt 1973 · S/N 1710R N5511XBruces Flying Service Inc · Arlington, GABuilt 1973 · S/N 1711R N5526XFarm And Ranch Aviation Co · Deming, NMBuilt 1973 · S/N 1726R N5527XCarson John D · Garber, OKBuilt 1973 · S/N 1727R N5532XJohnson Airspray Inc · Argyle, MNBuilt 1973 · S/N 1732R N5543XCroom Aviation LLC · Port Saint Joe, FLBuilt 1973 · S/N 1743R N5551XJohnson Airspray In · Argyle, MNBuilt 1973 · S/N 1751R N5569XHauger Mike S · Grangeville, IDS/N 1769R N5579XPacific Ag Services Inc · Firebaugh, CABuilt 1973 · S/N 1779R N5590XHawke Aviation Inc · Oakdale, CABuilt 1972 · S/N 1690R N5598XBlades Paul Andrew · Newman, CABuilt 1972 · S/N 1698R N5599XLakeview Aviation Inc · Sanborn, NDBuilt 1972 · S/N 1699R N5603XBoeing Co · Renton, WABuilt 1973 · S/N 1803R N5613XBob Ruhe Ag Service LLC · Leipsic, OHBuilt 1973 · S/N 1818R N5642XScott Cattle Company LLC · Burlington, COBuilt 1973 · S/N 1842R N5644XBellamy Mark A · Freeville, NYBuilt 1973 · S/N 1844R N5646XFountain Inc · Moscow, IDBuilt 1973 · S/N 1846R N5658XRca Aviation Ltd · Northwood, NDBuilt 1973 · S/N 1858R N5661XCarson Glen W · Garber, OKBuilt 1973 · S/N 1861R N5662XChorman Jeffrey A · Milford, DEBuilt 1973 · S/N 1862R N5663XMid Continent Aircraft Corp · Hayti, MOBuilt 1973 · S/N 1863R N5679XVanderpool Gary W · Alamo, TXBuilt 1974 · S/N 1879R N5680XPrecision Aerial LLC · Coleman, GABuilt 1974 · S/N 1880R N5730XCarmichael Matthew G · Presque Isle, MEBuilt 1977 · S/N 2385R N626RGGoering Ryan I · Prineville, ORS/N 1660R N704SFSchindler Flying Inc · Neligh, NEBuilt 1969 · S/N 1500R N8807QBluestem Aerial Sprayers LLC · Cushing, OKBuilt 1969 · S/N 1507R N8810QWest Valley Aviation Inc · Five Points, CABuilt 1970 · S/N 1510R N8811QRandy Goering Inc · Bend, ORBuilt 1969 · S/N 1511R N8815QFarm & Ranch Aviation Co · Deming, NMBuilt 1970 · S/N 1515R N8817QRuhe Sales LLC · Leipsic, OHBuilt 1970 · S/N 1517R N8828QMamuzich Robert J · Deming, NMBuilt 1970 · S/N 1528R N8841QHawke Ag Aviation · Oakdale, CAS/N 1671R N8865QOlsem Aerial Application Services LLC · Westbrook, MNBuilt 1969 · S/N 1465R N8866QSchott Ag Air LLC · Burns, ORBuilt 1969 · S/N 1466R N8878QAugustin Don M · Crystal, NDBuilt 1969 · S/N 1478R N887ATAgri-Air Inc · Chamberlain, SDBuilt 1973 · S/N 1725R

Back to Aero Commander S2R