Skip to content

Registered aircraft · 115

Aircraft of this model 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 aircraft_model_code IN ('6150162')
  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 aircraft_model_code IN ('6150162')
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.

N4806KRidpath James A Jr · Lubbock, TXBuilt 1949 · S/N NAV-4-1806 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 N4827KKirst Forest M · Fairbanks, AKBuilt 1949 · S/N NAV-4-1827 N4836KDickerson William A · Lancaster, OHBuilt 1949 · S/N NAV-4-1836 N4837KHawks Flight Team Inc · Ventura, CABuilt 1949 · S/N NAV-4-1837 N4845KWestlake-Toms James S · Tullahoma, TNBuilt 1949 · S/N NAV-4-1845 N4846KIngold Terry L · Albemarle, NCBuilt 1949 · S/N NAV-4-1846 N4855KPathfinder Aero Services LLC · Sheridan, WYBuilt 1949 · S/N NAV41855 N4856KMontcalm Aviation LLC · Coral, MIBuilt 1949 · S/N NAV-4-1856 N4859KRegistered aircraftBuilt 1949 · S/N NAV-4-1859 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 N4884KDresback Glen L · Cleveland, OKBuilt 1949 · S/N NAV-4-1884 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 N4891KLatham Raymond E Jr · Westerville, OHBuilt 1949 · S/N NAV-4-1891 N48JRHolmes Marion L · Ledbetter, TXBuilt 1950 · S/N NAV-4-2038 N4910KGarrison Patrick L · Oregon City, ORS/N NAV-4-1910 N4913KRabbit Hole Solutions LLC · Helena, MTS/N NAV-4-1913 N4934KPapp John F · Hanson, MABuilt 1949 · S/N NAV-4-1934 N4945KMyers Dwight E · Spencerport, NYBuilt 1949 · S/N NAV-4-1945 N4949KMaples Jeffrey · Wilmington, DEBuilt 1949 · S/N NAV-4-1949 N4963KThompson Benjamin · Salt Lake City, UTBuilt 1949 · S/N NAV-4-1963 N4964KButton Benjamin · Meridian, IDBuilt 1949 · S/N NAV-4-1964 N4971KFandrei Scott A · Kenosha, WIBuilt 1949 · S/N NAV-4-1971 N4978KSwett David C · Valencia, CABuilt 1949 · S/N NAV-4-1978 N4983KAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1949 · S/N NAV-4-1983 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 N4996KTraczyk Alisha M · Stow, OHBuilt 1949 · S/N NAV-4-1996 N4AVSouthwest Aircraft LLC · Fairacres, NMBuilt 1949 · S/N NAV-4-1844 N5040KRobinson Michael David · Folkston, GAS/N NAV-4-1695 N507MDArmitage Donald W · New Derry, PAS/N NAV-4-2080 N5100KAldrich David G · Naples, FLBuilt 1950 · S/N NAV-4-2000 N5102KAnderson Oluf J · Rangely, COS/N NAV-4-2002 N5111KGordon Caleb · Waukesha, WIBuilt 1950 · S/N NAV-4-2011 N5123KNavion West Inc · Northridge, CABuilt 1950 · S/N NAV-4-2023 N5124KMorrison Arthur T · Lexington, NCBuilt 1950 · S/N NAV-4-2024 N5136KSchwab Michael I · Burnside, ILBuilt 1950 · S/N NAV-4-2036 N5142KKuehn James M · Minden, NES/N NAV-4-2042 N5182KFleming Robert B · Snellville, GABuilt 1950 · S/N NAV-4-2082 N5186KBlacker Squadron LLC · Flemington, NJBuilt 1950 · S/N NAV-4-2086 N5205KConway Michael F · Keene, NHBuilt 1950 · S/N NAV-4-2105 N5206KNorthwest Navion Inc · Arlington, WAS/N NAV42106

Back to Ryan NAVION A