Skip to content

Registered aircraft · 829

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

N2639WBrown Jeffrey R · Leesburg, FLBuilt 1966 · S/N 976 N2644WMoran Robert D Jr · Plano, TXBuilt 1966 · S/N 979 N2648WDeghetto Richard D · Hopkinsville, KYBuilt 1966 · S/N 981 N2649WTeeter Joseph Jerald · Lisbon, OHBuilt 1966 · S/N 982 N2650WBrown Danny L · Wichita, KSS/N 983 N2653WDyer Perri P · Argyle, TXS/N 984 N2658WPerez Dennys · Orlando, FLBuilt 1966 · S/N 987 N2659WMooney Flyer LLC · Belton, SCBuilt 1966 · S/N 1007 N2660WDeptula John R · Pinehurst, NCBuilt 1966 · S/N 989 N2668WJarchow John H · Denison, TXBuilt 1966 · S/N 993 N2669WAlecci Alexander Drew · Sanford, FLBuilt 1966 · S/N 994 N2673WAdolf Charles P · Ocala, FLBuilt 1966 · S/N 996 N2674WHough Publishing LLC · Atlanta, GABuilt 1966 · S/N 997 N2678WLansford Company Inc · Lampasas, TXBuilt 1966 · S/N 999 N267WSErvin Andrew · Centennial, COBuilt 1966 · S/N 1000 N2680WNielson Michael James · Spanish Fork, UTBuilt 1966 · S/N 1001 N2683WSabagh Steve B · Maricopa, AZBuilt 1966 · S/N 1002 N2689WLocke Timothy S · Fort Irwin, CABuilt 1966 · S/N 1006 N2694WDickerson Steven Micheal · Tipp City, OHBuilt 1966 · S/N 1009 N2698WLivesay Wallace · Friendswood, TXBuilt 1966 · S/N 1011 N2699WKingman Connor Joseph · Lemoore, CAS/N 1012 N2700WHughes Karen A · Dandridge, TNBuilt 1966 · S/N 1015 N2701WWadsworth Van W · Sidney, OHBuilt 1966 · S/N 1016 N2706WElliott Frank F · Mojave, CABuilt 1966 · S/N 1019 N2711WAerotec LLC · Denver, NCBuilt 1966 · S/N 1022 N2716WBig Sky Aviation LLC · Meridian, IDBuilt 1966 · S/N 1025 N2719WNance Russell · Pelion, SCBuilt 1966 · S/N 1026 N2720WSharbono Dennis E · Billings, MTBuilt 1966 · S/N 1027 N2725WMorris Curtis D · Magnolia, TXS/N 1029 N2731WUsrey Curtis R · Sullivan, INBuilt 1966 · S/N 1033 N2732WReik Martina · Novi, MIBuilt 1966 · S/N 1034 N2736WMcnamara Jeffrey E Trustee · Riverside, CABuilt 1966 · S/N 1036 N2740WBakewell Keith · Independence, LABuilt 1966 · S/N 1038 N2741WEdison Robert J · Anchorage, AKBuilt 1966 · S/N 1039 N2742WStraub R L DBA · Stanton, TXBuilt 1966 · S/N 1040 N2745WGarnello John L · Palatine, ILBuilt 1966 · S/N 1041 N2750WVance John · Coleman, TXBuilt 1966 · S/N 1044 N2752WL Deckard Aviation Ministries · Waller, TXS/N 1167 N2755WEast Rick · Muscle Shoals, ALFirst renewal noticeBuilt 1966 · S/N 1047 N2756WJohnson Stephen C · Lake Tapps, WABuilt 1966 · S/N 1048 N2757WDennis Christopher A · Richardson, TXBuilt 1966 · S/N 1049 N2760WHardin Robert S · Renton, WABuilt 1966 · S/N 1050 N2762WRouth Frank D · Marion, NCBuilt 1966 · S/N 1052 N2765WBriseno Anthony · Virginia Beach, VABuilt 1966 · S/N 1168 N2767WMorrow Frank D · Wooster, OHBuilt 1966 · S/N 1055 N2770WSteele John A · La Habra, CABuilt 1966 · S/N 1056 N2771WMooney Patrick D · Anacortes, WABuilt 1966 · S/N 1057 N2776WBowers Curt E · Jennings, LAS/N 1060 N2785WNienaber David K · Colorado Springs, COBuilt 1966 · S/N 1065 N2787WWhite Gary L · Ashland, KSBuilt 1966 · S/N 1067

Back to Mooney M20E