Skip to content

Continental E185 series

Registered aircraft · 1,107

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

N4815KLan Aero Pro LLC · Sanford, FLBuilt 1949 · S/N NAV-4-1815 N4819KSmith Lance O · Gardiner, NYBuilt 1949 · S/N NAV-4-1819 N481YAZimny Jaroslaw Marek · Lombard, ILS/N NAV-4-1867 N4820KFinet Philip G · Venetia, PABuilt 1949 · S/N NAV-4-1820 N4821KRegistered aircraftBuilt 1949 · S/N NAV-4-1821 N4822KOld Girl LLC · Portage Des Sioux, MOBuilt 1949 · S/N NAV-4-1822 N4831KAnderson Oluf J · Rangely, COS/N NAV-4-1831 N4833KNoll Roddy B · Apison, TNBuilt 1949 · S/N NAV-4-1833 N4836KDickerson William A · Lancaster, OHBuilt 1949 · S/N NAV-4-1836 N4837KHawks Flight Team Inc · Ventura, CABuilt 1949 · S/N NAV-4-1837 N4847KRocha Julio Cesar · Redding, CAS/N NAV-4-1847 N484KHaines John P · Newcomerstown, OHBuilt 1946 · S/N NAV-4-148 N4851KFulk Richard D · Keller, TXBuilt 1949 · S/N NAV-4-1851 N4853KBeaver Bradford P · Miami, FLBuilt 1949 · S/N NAV-4-1853 N4858KYarbrough Lloyd Houston · Harlingen, TXBuilt 1949 · S/N NAV-4-1858 N4859KRegistered aircraftBuilt 1949 · S/N NAV-4-1859 N4862KSuggs Clyde C · Snow Hill, NCBuilt 1949 · S/N NAV-4-1862 N4869KTucker Robert B · Melba, IDBuilt 1949 · S/N NAV-4-1869 N486BSale Reported · Nixa, MOSale reportedS/N D-1506 N4874KBaker Loyal P · Dayton, WABuilt 1949 · S/N NAV-4-1874 N4878KStotz Robin · Corpus Christi, TXBuilt 1949 · S/N NAV-4-1878 N4880KLarsen Peter A · Alcester, SDBuilt 1949 · S/N NAV-4-1880 N4882KLambert Karl W · West Jefferson, NCBuilt 1949 · S/N NAV-4-1882 N4885KHollister William H · Nelson, NHBuilt 1949 · S/N NAV-4-1885 N4887KAnderson Kirby L · Mc Veytown, PABuilt 1949 · S/N NAV-4-1887 N4889KHolcomb James C II · Ware Shoals, SCBuilt 1949 · S/N NAV-4-1889 N48CBWells Bryan G · Stephenville, TXBuilt 1950 · S/N D-2203 N48JBN48jb LLC · Imperial, MOBuilt 1948 · S/N D-1371 N48JRHolmes Marion L · Ledbetter, TXBuilt 1950 · S/N NAV-4-2038 N4900KKnoll Thomas R · Ham Lake, MNBuilt 1949 · S/N NAV-4-1900 N490PAnthony Ballone · Tulsa, OKRevoked, canceledBuilt 1948 · S/N D-1510 N4921KSutton Steven D · Elk Grove, CAS/N NAV-4-1921 N4927KMeinen Albert D · Troy, ILBuilt 1949 · S/N NAV-4-1927 N4929EDavidson Joseph K III · Kansas City, MOS/N NAV-4-1714 N4936KHill Daniel R · Mount Sterling, KYS/N NAV-4-1936 N494BStutzman Frank C · Caldwell, IDBuilt 1948 · S/N D-1514 N4951CBradley Albert · Vacaville, CAS/N NAV-4-1784 N4951VBranam John R · Clinton, TNBuilt 1952 · S/N D-3197 N4952KJed Homes Inc · Lisbon, CTBuilt 1949 · S/N NAV-4-1952 N4955KWtf Aviation LLC · Aurora, COS/N NAV41955 N4956KSilver Wings Trading LLC · Leander, TXBuilt 1949 · S/N NAV-4-1956 N4957KClendenin Duncan M · Burlingame, CAS/N NAV-4-1957 N4963KThompson Benjamin · Salt Lake City, UTBuilt 1949 · S/N NAV-4-1963 N4971ETomlin Jonathan S · Georgetown, OHS/N NAV-4-1646 N4973KMccutcheon Michael R · Frederick, MDBuilt 1949 · S/N NAV-4-1973 N4978KSwett David C · Valencia, CABuilt 1949 · S/N NAV-4-1978 N497BWillis James R · Belleview, FLBuilt 1948 · S/N D-1518 N4986KScholl Marc David · Frisco, TXBuilt 1949 · S/N NAV-4-1986 N4990KWise Electronic Systems Inc · Windsor, PABuilt 1949 · S/N NAV-4-1990 N4991KKragt Phil D · Sheldon, IABuilt 1949 · S/N NAV-4-1991

Back to Continental E185 series