Skip to content

Registered aircraft · 98

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

N10YMDanhauer Christopher W · Marshall, TXBuilt 1961 · S/N 1753 N123LBloomfield Roger D · Nathrop, COBuilt 1962 · S/N 1808 N17DKDiamond B Farm Inc · Gamaliel, KYBuilt 1961 · S/N 1712 N3WPHagar Kevin J · Skiatook, OKBuilt 1961 · S/N 1820 N657TBWilson Adrian H · Orange Park, FLBuilt 1961 · S/N 1901 N6764CMac'S Seaplane Service LLC · Milan, INS/N 1802 N6BPDevoll Jeffrey · Sacramento, CAS/N 1823 N74501Barnes Michael N · Lindstrom, MNBuilt 1961 · S/N 1812 N74502Land Dustin M · Bascom, FLBuilt 1961 · S/N 1813 N74505Registration Pending · Redlands, CARegistration pendingBuilt 1961 · S/N 1816 N74507Bas Part Sales LLC · Greeley, COBuilt 1961 · S/N 1818 N74510Hood Joseph L · Ann Arbor, MIBuilt 1962 · S/N 1904 N74511A & D Wings LLC · Clarkston, MIBuilt 1961 · S/N 1822 N74513Munasinghe Chanaka · Portland, ORBuilt 1961 · S/N 1824 N74514Krupinski Floyd M · Chugiak, AKBuilt 1961 · S/N 1825 N74516Daniel Gary T · Athens, GABuilt 1961 · S/N 1827 N74517Linstad Daniel E · Canby, ORBuilt 1961 · S/N 1906 N74522Blue Line Holding LLC · Little Falls, MNBuilt 1961 · S/N 1833 N74525Barnard Vaughn N III · Raleigh, NCS/N 1836 N74527White Jesse J · Penn Valley, CAS/N 1838 N74529Harris Nathan J · Preston, IDBuilt 1961 · S/N 1840 N74533Whalen Shenandoah · Amelia, OHBuilt 1961 · S/N 1844 N74535Rodgers Doyle W · Longview, TXBuilt 1961 · S/N 1846 N74542Bauerle Lucas W · Albuquerque, NMBuilt 1961 · S/N 1853 N74545Hopkins Tim W · Cincinnati, OHBuilt 1961 · S/N 1911 N74547Travierso Alan S · Farmington, UTBuilt 1961 · S/N 1913 N74549Woodyard Tory · Mcloud, OKBuilt 1961 · S/N 1914 N74551Maldonado Edward R · Independence, ORBuilt 1961 · S/N 1862 N74562Hamm Donald S · Carrollton, TXS/N 1873 N74565Shai Evan · Oak Bluffs, MABuilt 1961 · S/N 1876 N74566Kerns Stanley M · Berryville, VABuilt 1961 · S/N 1877 N74568Willis Charles D · Katy, TXBuilt 1961 · S/N 1879 N74571Mccurry Richard H · El Dorado, CABuilt 1961 · S/N 1882 N74573Strout Adam Geoffrey · Manchester, MABuilt 1961 · S/N 1884 N74576Varnes Mark R · Westminster, CAS/N 1887 N74579Bethell A Ray · Heavener, OKBuilt 1961 · S/N 1890 N74581Lane Tyler R · Berthoud, COS/N 1892 N74582Moo Nee LLC · Vero Beach, FLBuilt 1962 · S/N 1893 N74586Rainwater Farms LLC · Dover, DES/N 1897 N74587Curtis David W · Watertown, NYBuilt 1961 · S/N 1898 N74700Sillitoe Jarin L · Mesquite, NVS/N 1800 N74701Du Sauzay Bart Jay II · Fayetteville, GAS/N 1899 N74704Tarpein Beau J · Newport, WABuilt 1961 · S/N 1704 N74705Lindberg Thomas W · Anchorage, AKBuilt 1961 · S/N 1705 N74707Becker Kurt G · Dexter, NMS/N 1707 N74710Alexander William R · Colleyville, TXBuilt 1961 · S/N 1710 N74714Gunnison Mark E · Beaverton, ORBuilt 1961 · S/N 1714 N74715Flying D LLC · Hinton, IABuilt 1961 · S/N 1715 N74718Jordan Victor M · Carson City, NVBuilt 1961 · S/N 1900 N74719Valerio Lori-Anne · Corona, CABuilt 1961 · S/N 1804

Back to Mooney M20B