Skip to content

Aero Commander 100

Registered aircraft · 94

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 ('0140202')
  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 ('0140202')
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.

N101VBergan Dennis M · Elkader, IABuilt 1969 · S/N 335 N2271TLynch Lawrence Michael · Tempe, AZBuilt 1969 · S/N 357 N2507KLabonte Stephen M · Gilford, NHBuilt 1968 · S/N 217 N269DACole Thomas Ed · White Settlement, TXBuilt 1968 · S/N 269 N27MHCurry Michael J · Ardmore, TNS/N 198 N2926TR And L Aero LLC · Dyersburg, TNS/N 046 N2927TAltitude Aviation Services LLC · Mountain Home, IDBuilt 1967 · S/N 066 N2928TWeaver Mitchell C · Howard, PABuilt 1967 · S/N 067 N2941TGiermek Peter T · Olean, NYBuilt 1967 · S/N 057 N2944TKneuper Felix E · Groves, TXBuilt 1967 · S/N 060 N2946TNorlund Christopher Scott · Safford, AZS/N 070 N2948TCoyle Jack R · Neosho, MOBuilt 1967 · S/N 072 N2950TRandall Aviation LLC · Arvada, COBuilt 1967 · S/N 075 N2952TWalters James F · Richton, MSBuilt 1967 · S/N 077 N2953TZavalney Carl G · Pollocksville, NCBuilt 1967 · S/N 078 N2985THuskey Ryan J · Guthrie, OKBuilt 1967 · S/N 059 N2999TAnderson Richard C · Dickson, TNBuilt 1966 · S/N 039 N3601XHarrell Joshua Thomas · Forsyth, GABuilt 1968 · S/N 298 N3626XJameson John M · Enid, OKBuilt 1969 · S/N 354 N3627XMonagas Jose · Lehigh Acres, FLBuilt 1969 · S/N 355 N3631XLee Brent · Cumming, GABuilt 1969 · S/N 359 N3640XDoerhoff Daniel L Trustee · Lone Jack, MOBuilt 1969 · S/N 348 N3643XBurbey Mark G · Racine, WIS/N 301 N3645XAubrey James M · North Little Rock, ARBuilt 1968 · S/N 302 N3659XAiello Bailey H · Eugene, ORBuilt 1968 · S/N 311 N3664XLurie Steven C · Delta, ALBuilt 1968 · S/N 314 N3670XDoerhoff Daniel L Trustee · Lone Jack, MOBuilt 1969 · S/N 317 N3676XLeszczynski Walter D · Georgetown, KYBuilt 1969 · S/N 321 N3678XS&S Aircraft LLC · Cushing, OKS/N 322 N3769XWiley John M · Lacey, WAS/N 261 N3770XLaux Robert M · Holladay, TNBuilt 1968 · S/N 262 N3771XRegistration Pending · Madison, GARegistration pendingBuilt 1968 · S/N 263 N3773XFerris David L · Kerrville, TXS/N 266 N3776XSkyline Aircraft Maintenance Inc · Nampa, IDBuilt 1968 · S/N 270 N3778XChang Tim C · Ocala, FLBuilt 1968 · S/N 271 N3781XN3781x LLC · Puyallup, WABuilt 1968 · S/N 275 N3782XBrown David L · Flemington, WVBuilt 1968 · S/N 276 N3785XWalker Dennis H · Tyler, TXBuilt 1968 · S/N 280 N3786XTinaglia J Dean · Hot Springs, SDBuilt 1968 · S/N 281 N3799XWilson Ricky A · Santa Teresa, NMS/N 297 N3853XStangel Eric K · Enterprise, ORBuilt 1967 · S/N 145 N3854XApplegate Ronald E · Rosamond, CABuilt 1967 · S/N 146 N3856XIce Cody W II · Houston, MOBuilt 1967 · S/N 149 N3860XOverall Aviators LLC · Parsons, KSBuilt 1967 · S/N 155 N3871XJohnson Roger L · Broken Arrow, OKBuilt 1967 · S/N 168 N3872XBehrens Bros Aviation LLC · Gerald, MOBuilt 1967 · S/N 170 N3874XTr Flying Service LLC · Milan, MNBuilt 1967 · S/N 173 N3875XTate Maurice J · Hope Valley, RIS/N 174 N3876XFlying Weenie LLC · Henderson, TXBuilt 1967 · S/N 175 N3881XVincent Ricky M · Clinton, LABuilt 1967 · S/N 184

Back to Aero Commander 100