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.

N408PSSebern Paul E · St Charles, ILBuilt 1979 · S/N 408 N4100Hanks Ronald G · Meridian, IDBuilt 1979 · S/N B-827 N41521Adams Terry · Stockton, CABuilt 2005 · S/N H-5141 N417MPetro Jerry R · Williamsburg, VABuilt 1958 · S/N PFA-417-1CM N420LVVan Dyke Robert Lee · Mesa, AZS/N 5195 N420VGGivens Jeffery N · Leavenworth, KSBuilt 2012 · S/N 001 N4215GHargrave Michael E · Marshalltown, IABuilt 1993 · S/N 001 N423WLysogorski Edward P · Bridgeport, MIS/N 001 N4241CPierce Mark O · Kansas City, MOBuilt 1988 · S/N 231 N4256Castleberry Robert F · Sanford, NCS/N SL-1 N426AGGoins Alan R · Virginia Beach, VABuilt 1997 · S/N 061892263 N426WDBudak Mark E · Melba, IDBuilt 2012 · S/N 0206020004111 N42880Wise Lynn A · Pegram, TNBuilt 2014 · S/N 15-2855 N429GSVoth Stephen R · Dequincy, LABuilt 2011 · S/N 0828 N4353EBrinson Dara H · Reidsville, NCBuilt 1992 · S/N GS 002 N4376YNelson Jack R · Portland, ORBuilt 1992 · S/N 235 N43MKGodbold Donald W · Camden, ALBuilt 2005 · S/N 0687 N43TDBruins Gregory · Moore, SCBuilt 1997 · S/N 001 N44145Sale Reported · Martinez, CASale reportedBuilt 2004 · S/N 82055-1 N4415TGregory George R · Springfield, MOBuilt 1983 · S/N 111948 N441RPGast William A · Spirit Lake, IABuilt 1985 · S/N 85K1160L N4439LMorris Francis B · Flemington, NJBuilt 1984 · S/N 125 N444GLLewis Gayle A · Galesburg, ILBuilt 1989 · S/N 759 N44774Ffrench Lawrence R Jr · Austin, TXBuilt 2014 · S/N 5111 N44KWWilkinson Kevin L · Grand Island, NEBuilt 2010 · S/N 614 N44WJFisher Jeffrey L · Thorndale, TXS/N 374 N455CXHrdlicka Thomas O · Foristell, MOBuilt 2014 · S/N 455 N455JSShaffer John Thomas · Fremont, OHBuilt 1984 · S/N 8009 N45BMRanck Clarence Martin Jr · Hilltop Lakes, TXS/N 77 N46778Hinkle Gary D · Middletown, PABuilt 1977 · S/N BAS001 N46PBCollier Charles R · Gloucester, VAFirst renewal noticeS/N 6707 N46RBHarrington Jeffrey L · Rockwell, NCS/N 702 N47169Goering David · Inman, KSBuilt 1977 · S/N V-1605 N472FSBuse Darek L · Kensington, MNS/N DAS-NLT 2012 N4761RSackman Arrow LLC · Glen Carbon, ILBuilt 2013 · S/N 004 N47CVRiffee Danny D · Elizabeth, WVBuilt 2007 · S/N 08224 N47DXParker Raymond E · Loveland, OHS/N 492 N47FTTeasdale Frederic A · Meadville, PABuilt 2012 · S/N 030309-1007 N47GLBailey Steven W · Puyallup, WABuilt 1985 · S/N 635 N47JWJungren Brett F · Elmwood, NEBuilt 1990 · S/N 6-1107 N480XNNalevanko Joseph Ivan · Kernersville, NCS/N T94503COHKO0118 N4862HWerner Richard Paul · Luebbering, MOS/N 325 N486DHHalstead John David · Fulton, NYBuilt 1998 · S/N 74-8578 N486MVVandelinder Martin A · Fulton, NYBuilt 1998 · S/N 74-8574 N49RGGodfrey Roger K · Ottumwa, IABuilt 1998 · S/N 398 N49TSJaeger Robert G · Lake City, FLS/N 1548LT N49WEMacdonald Gerald C · Newark, OHBuilt 1987 · S/N 12399A N4CXJohnson Russell G · Newark, DEBuilt 1994 · S/N 12931 N503WGZimmerman Frank M · Hudson, FLBuilt 2013 · S/N 0503 N50482Barrett Thomas M · Superior, WIBuilt 1984 · S/N 1

Back to Volkswagen CONVERSION