Skip to content

Aero Commander CALLAIR A-9B

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

N7259VKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1967 · S/N 1313 N7270VAirmotive Service LLC · Brigham City, UTBuilt 1967 · S/N 1320 N7603VHauser Linda L · Ulysses, KSBuilt 1967 · S/N 1331 N7617VSoaring Utah Inc · Sandy, UTBuilt 1967 · S/N 1345 N7629VMountain Air Spray Co · Craig, COBuilt 1967 · S/N 1357 N7648VMiller Jerold R · Deering, NDBuilt 1968 · S/N 1376 N7649VBoeing Co · Renton, WABuilt 1968 · S/N 1428 N7650VNorth Carolina Soaring Association · Zebulon, NCBuilt 1968 · S/N 1378 N7669VYpma Gene A · Harrison, MTBuilt 1968 · S/N 1397 N7678VHinckley David D · Belton, TXBuilt 1968 · S/N 1406 N7696VBoeing Co · Renton, WABuilt 1968 · S/N 1424 N7729VNew England Soaring Tug LLC · Perkinsville, VTBuilt 1969 · S/N 1480 N7742VNorbury Ross · Boonville, MOBuilt 1969 · S/N 1495 N7761VLangley Richard A · Sheyenne, NDBuilt 1969 · S/N 1518 N7768VSky Sailing Inc · Warner Springs, CABuilt 1969 · S/N 1525 N7772VHauser Linda L · Ulysses, KSBuilt 1969 · S/N 1515 N7774VMarshall Soaring Club Inc · Marshall, MIBuilt 1969 · S/N 1528 N7783VWarhol Peter J · Peever, SDBuilt 1970 · S/N 1536 N7786VZoom Schwartz LLC · Goldthwaite, TXS/N 1539 N7799VCb Aerial Application LLC · Kirksville, MOBuilt 1970 · S/N 1552 N7967VAnderson Cattle Co Inc · Emporia, KSBuilt 1971 · S/N 1576 N7991VNorth Carolina Soaring Association · Zebulon, NCBuilt 1970 · S/N 1586 N7998VDonica Leldon H · Marana, AZBuilt 1970 · S/N 1589

Back to Aero Commander CALLAIR A-9B