Skip to content

Dehavilland DHC-1 CHIPMUNK

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

N146DKHenningsen Henning L · Pewaukee, WIBuilt 1950 · S/N C1-0103 N19547Delaware Aviation Museum Foundation · Georgetown, DEBuilt 1951 · S/N C1-0482 N2247Registered aircraftBuilt 1942 · S/N C1-0765 N334JSchneider Mike · Inola, OKBuilt 1952 · S/N DH8F247 N388TDMulva Jonathan D · De Pere, WIBuilt 1952 · S/N CI-0730 N430WGRandall Steven J · Oakland, CABuilt 1951 · S/N C1-0504 N48044Bass William J · Lusby, MDBuilt 1951 · S/N WD-384 N48099Olson Cody · Grand Isle, VTBuilt 1952 · S/N WK-581 N48110Lowry Wilson R · Leonardtown, MDBuilt 1952 · S/N WD-285 N48260Moreau Robert Douglas · Granbury, TXBuilt 1953 · S/N DHB F 503 N48262Cavanagh Patrick D · Dubois, WYS/N DH8F-499 N4998TLewis Shane · Tulsa, OKBuilt 1950 · S/N C1-0214 N524BGDelker Westley R · Spring, TXS/N C1-0709 N53941Wb650 Raf Chipmunk LLC · Madison, ALBuilt 1950 · S/N 01-0088 N591WKBell Nicolette A · Wasilla, AKS/N C1-0615 N65350Williams Aviation Inc · Chapmansboro, TNS/N C1-0746/568 N6WGFlying L Aircraft Inc · Fort Denaud, FLBuilt 1951 · S/N WD-299 N7DWMeredith Mark S · Edgewater, MDBuilt 1951 · S/N B/F/370 N829WPPenderville John Edward · Purcellville, VAS/N C1-0710 N894WPStottlemyer Victor R · Hartland, WIS/N C1-0679/663 N9246ZLinares Jonathan E · Lancaster, CABuilt 1950 · S/N C1-0196 N9256ZSwain Edward E III · Kirksville, MOBuilt 1952 · S/N C1-0711 N939RBessett Daniel · Pleasant Hill, ORBuilt 1951 · S/N C1-0433

Back to Dehavilland DHC-1 CHIPMUNK