Skip to content

Ford CONVERSION

Registered aircraft · 66

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

N106DRRoodroets Bryan J · Caledonia, MIS/N 93-1 N116WWWest William Thomas · Clarksville, VABuilt 2006 · S/N 001 N123NSSwartzbaugh Neil L · Mason, ILBuilt 1989 · S/N NS-1 N12938Lovley Forrest T · Jordan, MNBuilt 1970 · S/N EMS-1 N12942Davis Trenten E · Brodhead, WIBuilt 1972 · S/N SL1 N130WHWoodard Russell E · Toney, ALBuilt 1990 · S/N 130 N13691Rudolf Pietenpol Flying Club LLC · Brodhead, WIBuilt 1933 · S/N 1 N14482Olson James A · Hixton, WIBuilt 1975 · S/N RFP-75 N1492GJenkins George Merritt · Wayne, PABuilt 1994 · S/N 221492 N152JMSmokovitz Daniel J · Brighton, MIBuilt 1987 · S/N 152 N15767Dean James J · Sanford, NCS/N 1 N17093Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1936 · S/N 13 N17288Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1984 · S/N 1 N18018R Douthitt Enterprises Inc · El Centro, CABuilt 1937 · S/N 31 N18224Alfred & Lois Kelch Aviation Museum Inc · Brodhead, WIBuilt 1937 · S/N 20 N1929FFaith Jeffrey A · Louisville, KYBuilt 2012 · S/N JAF1929 N192MSmith James E Trustee · Kalispell, MTBuilt 1992 · S/N M1-92 N1932GFreeman Heritage Collection LLC · Kingsbury, TXS/N VA2 N1933AWestern Antique Aeroplane & Automobile Museum · Hood River, ORS/N 007 N1940Laudani Alan A · Bay City, ORBuilt 1991 · S/N 1 N20548Allred Carey D · Grantsville, UTS/N JV001 N20SFSanders Aircraft Inc · Ione, CABuilt 1956 · S/N ES-9505 N217DBBauer Dereck R · Springfield, ORS/N 1 N21SCountry Club Mortgage LLC · Grain Valley, MOBuilt 1995 · S/N 22114 N250BSStarduster Too Aviation LLC · The Woodlands, TXBuilt 1987 · S/N 1 N26VKVkp Group Inc · Minneapolis, MNS/N VK2 N301BCWelch Associates Inc · Owasso, OKS/N E20T N311GPPhillips Brett D · Strasburg, VAS/N PIET-1930-94 N3249HHistoric Aircraft Restoration Museum · Saint Louis, MOBuilt 2006 · S/N 3 N34KPRoller Richard D · Olathe, KSBuilt 2000 · S/N 6 N351DFRuth Howard · Clark Fork, IDS/N 769 N3706Registration Pending · Windcrest, TXRegistration pendingBuilt 1974 · S/N 405 N3768QNewhouse Hayden V · Fredericksburg, TXBuilt 1980 · S/N PC1-1A N42DLMassey Air Museum Inc · Massey, MDBuilt 1993 · S/N LA421 N42PDLamont Christopher B · Aberdeen, SDS/N 1266 N4483NMalley Jim · Jersey City, NJBuilt 1989 · S/N JM-1 N4717Sale Reported · Union Grove, WISale reportedS/N AAA-1 N497ARDeal Gregory A · Morganton, NCBuilt 1999 · S/N LCF2 N51BVPieper Patrick G · Keene, CAS/N 7551-1 N51JRArmstrong Charles W · Midland, TXBuilt 1984 · S/N 002 N54NDougherty Paul D · Bethel, PABuilt 2000 · S/N 1 N57FGGleiter Frederic M · Cochrane, WIBuilt 1994 · S/N G-5 N599Anderson Mark A · Bates City, MOBuilt 1989 · S/N 1989-1 N6286ATroy Michael J · Albion, NYBuilt 1996 · S/N MJT-01 N629WLLarison Winston L · Galveston, TXBuilt 2016 · S/N 002 N6351August Aero LLC · Kalispell, MTBuilt 1999 · S/N 002 N682BDHall Marty D · Leighton, ALBuilt 2000 · S/N 682 N687MBMcwhorter Jim · Bean Station, TNBuilt 1988 · S/N 2A N728MKGerard Luke T · Syracuse, KSBuilt 2011 · S/N DKS 001 N767FOwls Head Transportation Museum · Owls Head, MEBuilt 1962 · S/N 3712

Back to Ford CONVERSION