Skip to content

Aero Commander 500 S

Registered aircraft · 45

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

N129MBYellowfin Air Services LLC · Wilmington, DEBuilt 1971 · S/N 3108 N16JCRl Equipment And Services LLC · Monument, COBuilt 1972 · S/N 3128 N17DLPonderosa Aviation LLC · Safford, AZBuilt 1969 · S/N 1866-42 N1938SCavu Aviation LLC · North Yarmouth, MEBuilt 1973 · S/N 3167 N202JHPerrin Michel · Austin, TXBuilt 1973 · S/N 3145 N210HDPonderosa Aviation LLC · Safford, AZBuilt 1969 · S/N 1841-33 N214JADer Aviation LLC · Dover, TNS/N 3122 N244ACScruggs Ken · Galloway, OHBuilt 1968 · S/N 1815-21 N33PGFoundation Of Wayne Community College Inc · Goldsboro, NCS/N 1782-5 N39GWKotalite Consultant LLC · West Palm Beach, FLS/N 3096 N3UVPonderosa Aviation LLC · Safford, AZBuilt 1973 · S/N 3146 N444TSUig Transport LLC · Raleigh, NCBuilt 1974 · S/N 3182 N47ACReabe Aircraft Improvement Inc · De Pere, WIBuilt 1974 · S/N 3200 N4QSPonderosa Aviation LLC · Safford, AZBuilt 1968 · S/N 1755-1 N500HMTalos Aviation Group LLC · Blackstone, VABuilt 1973 · S/N 3155 N500RXGiesler Gary J · Hermann, MOS/N 3207 N500SJAir Data Solutions LLC · Natchitoches, LAS/N 3149 N500VEGame On Aviation LLC · Charlotte, NCBuilt 1972 · S/N 3133 N519WATropeano Construction Inc · Belleview, FLBuilt 1970 · S/N 3081 N531SASpur Aviation Services Lc · Twin Falls, IDBuilt 1969 · S/N 3059 N532SA2flyshrike LLC · Miramar, FLBuilt 1969 · S/N 1868-44 N533SASpur Aviation Services Lc · Twin Falls, IDBuilt 1968 · S/N 1786-9 N536SAMx Leader LLC · Monterey, CABuilt 1973 · S/N 3169 N57084Sunflower Aviation LLC · Wilmington, DEBuilt 1974 · S/N 3184 N571DCMay Phillip Edward · Florence, ALBuilt 1971 · S/N 3099 N57266Department Of Public Safety · Baton Rouge, LABuilt 1974 · S/N 3208 N590DRRichardson Dean A · St Thomas, VIBuilt 1968 · S/N 1817-23 N634CTCorsair Aviation LLC · Yuba City, CABuilt 1972 · S/N 3121 N6619VTeton Leasing LLC · Pocatello, IDBuilt 1968 · S/N 1824-24 N741CAHarold F Mowery · Mechanicsburg, PABuilt 1974 · S/N 3191 N760VRSkyway II LLC · Naples, FLBuilt 1972 · S/N 3138 N787RKEpitrop Foundation · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1968 · S/N 1832-29 N799CERed Oar Aviation LLC · Lookout Mountain, TNS/N 1807-17 N811PJObrien Neal J · Milton, GABuilt 1969 · S/N 3051 N8LXAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 3065 N9080NBoeing Co · Renton, WABuilt 1969 · S/N 3066 N9096NStones River Aviation LLC · Murfreesboro, TNBuilt 1969 · S/N 3076 N90JPAec Shrike LLC · Barrington, ILBuilt 1970 · S/N 3078 N9159NBoeing Co · Renton, WABuilt 1971 · S/N 3113 N915PRAvialogia Inc · CancunS/N 3126 N9160NBoeing Co · Renton, WABuilt 1971 · S/N 3114 N9177Chaffin Christopher · Flower Mound, TXBuilt 1972 · S/N 3125 N9186NShrike One LLC · Deerfield Beach, FLBuilt 1972 · S/N 3131 N957JACbmw LLC · Wise, VABuilt 1978 · S/N 3308 N975AAEmez Holdings LLC · Boca Raton, FLBuilt 1974 · S/N 3175

Back to Aero Commander 500 S