Skip to content

Dehav ENG GIPSY MAJOR

Registered aircraft · 89

Aircraft with this engine 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 engine_model_code IN ('20004')
  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 engine_model_code IN ('20004')
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.

N101JFZimmerman Keith D · Whitesburg, GABuilt 1950 · S/N CI0135 N11CHBish Brent A · Leland, ILBuilt 1950 · S/N 135 173 N12739Hirtle Joel M · Westerville, OHBuilt 1932 · S/N 4026 N1300DHammerle Edward A · Schuyler Lake, NYBuilt 1944 · S/N 86504 N143PHolmes Mark K Trustee · Salem, ORBuilt 1950 · S/N 105 143 N14659Von Bevern Brian J · Overland Park, KSBuilt 1942 · S/N A17-659 N16653Tca Aviation LLC · Bowling Green, KYBuilt 1947 · S/N TAY220V N17440Harris David M · Kenosha, WIBuilt 1951 · S/N T208 N17489Reber Alan L · Indianapolis, INBuilt 1940 · S/N A17-489 N178DCJolley Matthew J · Carrollton, GABuilt 1950 · S/N 178 N18048Sale Reported · Lavala QuebecSale reportedBuilt 1956 · S/N 186/224 N1937DDakota Heritage Inc Trustee · Wilmington, DEBuilt 1937 · S/N 3621 N19547Delaware Aviation Museum Foundation · Georgetown, DEBuilt 1951 · S/N C1-0482 N221JCox Scott A · Delphos, OHBuilt 1963 · S/N 1705 N22777Whyte Eric · Franklin, WIBuilt 1950 · S/N C1-0105 N2726AGrace Ian B · Sultan, WABuilt 1954 · S/N V4760 N34DHKimbrel Martin E · Oakville, WABuilt 1934 · S/N 6096 N3529King David T · Red Hook, NYBuilt 1945 · S/N PG647 N3549Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1945 · S/N PG645 N3675Bain Stuart Micael · Lake Ronkonkoma, NYBuilt 1947 · S/N TAY859BJ N371DHManiatis Michael · Milton, NYBuilt 1995 · S/N 001 N3758UAntique Preservation Assn Greenfield · Greenfield, IABuilt 1941 · S/N 1269 N38KHBavarian Barnstormers 2 Inc · North Fort Myers, FLS/N T8256 N417WMyhr Patrick W · Lake Isabella, CAS/N 12Q-2030 N41DHVoyager 180 LLC · Windsor, COBuilt 1972 · S/N 84734 N420TDFoskett James J · Pewaukee, WIS/N C1-0532 N430WGRandall Steven J · Oakland, CABuilt 1951 · S/N C1-0504 N431WGHarris David M · Kenosha, WIBuilt 1951 · S/N C1-0505 N439WAlfred And Lois Kelch Aviation Museum Inc · Brodhead, WIBuilt 1931 · S/N 2005 N459DEFrederick Jeffrey R · Tallahassee, FLS/N 85455 N48044Bass William J · Lusby, MDBuilt 1951 · S/N WD-384 N48099Olson Cody · Grand Isle, VTBuilt 1952 · S/N WK-581 N48260Moreau Robert Douglas · Granbury, TXBuilt 1953 · S/N DHB F 503 N482DHGerhardt Michael C · Birmingham, ALBuilt 1937 · S/N 3713 N4942Steo Nicholas J Jr · Stuart, FLBuilt 1944 · S/N R-5063 N4996Aeroplane Co LLC · Sylvania, OHBuilt 1952 · S/N C1-0611 N5050CTiger Moth LLC · Huntington, INBuilt 1944 · S/N NL875 N520RBaker Nicholas · Rancho Cucamonga, CAS/N 82960 N522RWelch Robert E · Estero, FLBuilt 1935 · S/N T-7602 N524BGDelker Westley R · Spring, TXS/N C1-0709 N5300Mulhall Timothy P · Lampasas, TXBuilt 1940 · S/N T-5703 N53941Wb650 Raf Chipmunk LLC · Madison, ALBuilt 1950 · S/N 01-0088 N5444Thibault William N · Newport Beach, CABuilt 1935 · S/N 3312 N5446Schoning Harry · Driggs, IDBuilt 1941 · S/N A17-392 N555XBPort Townsend Aero Museum · Port Townsend, WABuilt 1938 · S/N 3852 N5562Bender Andrew J · Greenwood Lake, NYS/N 802 N559WKTsi Holdco Inc · Virginia Beach, VABuilt 1952 · S/N C1/0576 N57AUGillies Paul A · Marion, KYBuilt 1955 · S/N 3155 N58038Pollack Jack · Scottsdale, AZBuilt 1956 · S/N 176-214 N603DHManiatis Michael · Milton, NYBuilt 2006 · S/N 001

Back to Dehav ENG GIPSY MAJOR