Croman Corp

Registered aircraft · 35

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'CROMAN CORP' OR list_contains(g.other_registrant_names, 'CROMAN CORP')
  ORDER BY g.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.

N1043TSikorsky S-61A · S/N 61083Built 1961 · White City, ORN1048YSikorsky S-61A · S/N 61161Built 1961 · White City, ORN113WKSikorsky SH-3H · S/N 152113White City, ORN408FSSikorsky S-61N · S/N 61361Built 1966 · White City, ORN408UDSikorsky S-61N · S/N 61772Built 1974 · White City, ORN408WCSikorsky S-61N · S/N 61764Built 1977 · White City, ORN410GHSikorsky S-61N · S/N 61749Built 1975 · White City, ORN4263ASikorsky S-61R · S/N 61551Built 1966 · White City, ORN501CDCessna 501 · S/N 501-0066Built 1978 · White City, ORN611CKCroman SH-3H · S/N 148966Built 1961 · White City, ORN612CKCroman SH-3H · S/N 149713Built 1962 · White City, ORN613CKCroman SH-3H · S/N 152109Built 1965 · White City, ORN614CKSikorsky S-61N · S/N 61715Built 1974 · White City, ORN617CKSikorsky S-61N · S/N 61164Built 1962 · White City, ORN618CKSikorsky S-61NM · S/N 61454White City, ORN619CKSikorsky S-61N · S/N 61808First renewal noticeWhite City, ORN61NHSikorsky S-61N · S/N 61474Built 1970 · White City, ORN620CKSikorsky S-61L · S/N 61362White City, ORN621CKSikorsky S-61N · S/N 61364White City, ORN623CKSikorsky S-61N · S/N 61762Built 1977 · White City, ORN624CKSikorsky S-61A · S/N 61272Built 1964 · White City, ORN6259CBell 206B · S/N 703White City, ORN625CKSikorsky S-61N · S/N 61-216Built 1963 · White City, ORN626CKSikorsky S-61N · S/N 61220Built 1963 · White City, ORN628CKCroman SH-3H · S/N 152707Built 1966 · White City, ORN629CKSikorsky S-61N · S/N 61751Built 1975 · White City, ORN631CKSikorsky S-61N · S/N 61753White City, ORN635CKCroman SH-3H · S/N 149702Built 1962 · White City, ORN703WKSikorsky SH-3H · S/N 152703White City, ORN765AWSikorsky S-61N · S/N 61765Built 1976 · White City, ORN804ARSikorsky S-61N · S/N 61222Built 1964 · White City, ORN833ARSikorsky S-61N · S/N 61738Built 1974 · White City, ORN84CKBell 206B · S/N 2253Built 1977 · White City, ORN950DGSikorsky UH-3H · S/N 149724White City, ORN9696WSikorsky S-61A · S/N 61147Built 1960 · White City, OR
Back to Croman Corp