Skip to content

Aero Commander 500-A

Registered aircraft · 23

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

N152KWestern Capital Partners LLC · Wilmington, DEBuilt 1962 · S/N 500A-1258-82 N207ACSunflower Aerospace Holdings LLC · Shawnee Mission, KSS/N 500A-1266-89 N234WMBay Area Skymaster LLC · Pasadena, MDBuilt 1962 · S/N 500A-1257-81 N274LECsonka Bela · Hesperia, CABuilt 1962 · S/N 500A-1232-69 N311PWQuantic LLC · Morrisville, NCBuilt 1961 · S/N 500A-1106-54 N313MBosco74 LLC · Wilmington, DEBuilt 1963 · S/N 500A-1276-99 N333BENtn3n LLC · Titusville, FLBuilt 1960 · S/N 500A-979-33 N444BDAddington James T · Denton, TXBuilt 1960 · S/N 94629 N444WAWiseman Aviation Inc · Flagstaff, AZBuilt 1961 · S/N 1130-60 N471DAero Food Imports LLC · Dover, DEBuilt 1962 · S/N 500A-1240-70 N500TUAlpha Jets USA Inc · Clarksville, TXBuilt 1962 · S/N 500A-1259-83 N526RJN526rj LLC · Sulphur, OKBuilt 1961 · S/N 500A-1097-51 N6127XSalinas Manuel · Lamesa, TXBuilt 1960 · S/N 500A-970-32 N6136XGo Leasing Company · Phillipsburg, KSBuilt 1960 · S/N 500A-926-25 N6266XWells & West Inc · Murphy, NCBuilt 1962 · S/N 500A-1141-61 N6287XWallen Joe · Knoxville, TNS/N 500A-1250-75 N6296XDye Michael M · Bastrop, TXBuilt 1962 · S/N 500A-1254-78 N62LLAirborne Research LLC · Fort Pierce, FLBuilt 1961 · S/N 500A-1122-58 N78379Bottrell John E II · Yukon, OKBuilt 1962 · S/N 500A-1265-88 N800ACTango Gulf LLC · Naples, FLBuilt 1962 · S/N 500A-1193-65 N811DKucheck Alan · Yucca Valley, CAS/N 500A-1256-80 N887BDBolin Industries · Hamburg, ARBuilt 1963 · S/N 1249-74 N95ARPfaff Ben J · Bend, ORBuilt 1962 · S/N 500A-1270-93

Back to Aero Commander 500-A