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.

N925MLAhlman Frank H · Faribault, MNBuilt 1987 · S/N 1 N92JSFlagella Frank · Fredonia, NYBuilt 1985 · S/N 01420L11T N930RTO'Neal Brent K · Arlington, TXBuilt 1994 · S/N 93077 N93RMSparks Charles Ethan · Cornelius, NCBuilt 2011 · S/N 1012 N9441FSmith Kenneth C · Big Spring, TXBuilt 2007 · S/N 1408 N94524Bordelon Brent M · Mansura, LAS/N 128 N9483AEiland Eddie L · Dublin, TXBuilt 1979 · S/N 485 N94RFRinker Robert W Jr · Seattle, WAS/N 121292322 N94TLHubbell Jon E · Mc Cordsville, INBuilt 1995 · S/N 821 N9502ABone Robert R · Fort Wayne, INBuilt 1978 · S/N 401 N950HMMilholland Leonard E · Brookshire, TXS/N 15-1805 N979YENapper Paul R · Pocatello, IDBuilt 1976 · S/N 1 N9828SLydic Daniel A · Enterprise, ALBuilt 1986 · S/N 01375L N982AVJohnson Johnny G · Selma, NCBuilt 1982 · S/N 987 N9931Calvert Michael · Wichita, KSBuilt 2015 · S/N POE-1 N99550Edgerton Charles E · Durham, NCBuilt 1978 · S/N WDF-1-77 N995BGSanders Vernon J · Sparta, WIBuilt 1990 · S/N 995 N999RPJantzi Isaac J · Parma, IDS/N 151 N99RBZieger Bobby G · Austin, TXBuilt 1972 · S/N RB621945 N99TRRyan Thomas L · Northbrook, ILBuilt 1982 · S/N 206 N9FTKrueger Patrick T · Verona, WIBuilt 1979 · S/N 5-1442 N9JMMiller Gerald R · Palmer, AKBuilt 1975 · S/N 5-1080 N9PHEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1974 · S/N 109 N9WXDelimat Andrzej · Manitowoc, WIBuilt 1973 · S/N 112

Back to Volkswagen CONVERSION