Skip to content

Volkswagen CONVERSION

Registered aircraft · 374

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

N170RMAntique Preservation Association Of Greenfield · Greenfield, IABuilt 1998 · S/N 30 N17CWRundel Steve · Derby, KSBuilt 1977 · S/N 3CW-5 N185FLCovey Lawrence R · Port Saint Lucie, FLFirst renewal noticeBuilt 2009 · S/N 172 N191JPParrish Jimmy R · Plantation, FLBuilt 1995 · S/N 001 N191MRFerraro Joseph S · Chattaroy, WABuilt 1985 · S/N 5992 N191SViking Aircraft LLC · Elkhorn, WIBuilt 1977 · S/N 112 N1924MBrown Michael D · Safford, AZBuilt 2015 · S/N 12 N1929DBelcher Eric Ryan · Altamonte Springs, FLS/N 15-1589 N1967QPasley Larry R · Carlisle, ARBuilt 2014 · S/N VP1-042312-0345DDK N19GKKonrad Gary T · Howell, MIBuilt 1984 · S/N 109 N19LCDay Leroy Carter · Gordonsville, VABuilt 1988 · S/N LD-1 N2043PMarek Robert C · Cadott, WIBuilt 1993 · S/N BSP 2931 N204MTRobinson Colton Chad · Beaver, UTBuilt 2006 · S/N 212 N2050Loar Joshua D · Windber, PAS/N 1 N2071HStatz Herbert J · Waunakee, WIBuilt 2002 · S/N 001 N2072CMattix Aaron L · Independence, KSBuilt 1994 · S/N EMK5 N213TDDearing Ted E · Chandler, AZBuilt 2003 · S/N 1 N2198CWhitten Danny R · Porter, TXBuilt 1994 · S/N 5764 N219GKMiller Robert C · Tucson, AZS/N 303 N21KCDurossette Darryl · Eugene, ORBuilt 1976 · S/N KAC-1 N2204ZWesley Charles H Jr · Callahan, FLBuilt 1994 · S/N 8642 N2208COhrenberg Robert W · Harrah, OKBuilt 1978 · S/N 236 N2211BMcgilvra Michael · Des Moines, IAS/N MS-1 N2248VMeyer Stephen W · Hixton, WIBuilt 1994 · S/N KF7 N2263DHebron Randall C · Westland, MIBuilt 1979 · S/N 1 N2264KFox Terry L · Hubbard, ORBuilt 1999 · S/N 001 N2286WSmeltzer Paul C · Texarkana, ARBuilt 2018 · S/N 1 N22SWShultz Mary M · Loveland, OHS/N 523 N22VPDakota Territory Air Museum Inc · Minot, NDBuilt 1974 · S/N PS289 N233JBarnes Dennis L · Grants, NMBuilt 1980 · S/N MC-233 N234BCCrews William J · Jacksonville, FLBuilt 1990 · S/N V2 1443 N236CXBothwell Vernon E Jr · Cloverdale, INBuilt 2009 · S/N 236 N2460Medwetz Andrea L · Brooklyn, OHS/N 1 N2485FWautier Gerald J · Wisconsin Rapids, WIBuilt 2007 · S/N CCU 009 N248RKKlassy Ralph H · North Fond Du Lac, WIBuilt 1981 · S/N 00269 N24ABKoch Thomas R · Pierre, SDBuilt 1984 · S/N 1 N252EXTaylor Lewis D · Pikeville, TNBuilt 2014 · S/N 252 N2535NMartin Thomas S · Lebanon, OHBuilt 2008 · S/N 01448 N254EMWilcox Ross L · Santa Rosa, CABuilt 1990 · S/N 224190C N25JHSpicer Larry E · Milwaukee, WIS/N 51 N26091Davies William T · Auburn, WABuilt 1975 · S/N 1 N260NSRegistration Pending · Naperville, ILRegistration pendingBuilt 1985 · S/N 736 N26524Ramos Tommy D · Logan, UTS/N 001997 N26DGColley Douglas W · Spokane, WABuilt 1981 · S/N JD-564 N27257Moldaschel Charles J · Sleepy Eye, MNBuilt 1977 · S/N 5-10780 N276CXGayda Russell D · Santa Rosa, CABuilt 2014 · S/N 276 N276SPSimpson Benjamin J · Stratton, MES/N 276 N27867Brewer Rustin Porter · Vancouver, WABuilt 1984 · S/N 127 N27932Lesko Gerald J · Hollywood, MDBuilt 1983 · S/N 238 N28072Baker Glen A · Grand Island, NEBuilt 1974 · S/N 510531

Back to Volkswagen CONVERSION