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.

N10HVRegistered aircraftBuilt 1965 · S/N 715 N1200XLacola Joseph D · Commerce Township, MIBuilt 1963 · S/N 103 N1205XOsborn Aviation LLC · Claude, TXBuilt 1963 · S/N 183 N1206XNlw 1 LLC · Washington, UTS/N 184 N1210XDowdy Joseph N · Blacksburg, VABuilt 1963 · S/N 185 N1217XRanger Aviation Enterprises Inc · San Angelo, TXBuilt 1963 · S/N 187 N121EConger Martin D · Pasco, WABuilt 1963 · S/N 173 N121RLZaytsev Petr · Pflugerville, TXBuilt 1969 · S/N 690072 N1230XMarquez Christopher · Gaithersburg, MDBuilt 1963 · S/N 104 N1234KLatiolais Travis · Breaux Bridge, LABuilt 1966 · S/N 995 N1235XRudy Alan J · Phoenix, NYBuilt 1963 · S/N 108 N1236XFull Mooney LLC · Camden, DES/N 109 N1238XAljo Aircraft Corp · Arroyo Grande, CAS/N 111 N1239XAircraft Ownership Solutions LLC · Kokomo, INS/N 112 N123FAGlas Robert Sean · Lompoc, CABuilt 1966 · S/N 1204 N1240XPioneer Aviation LLC · Boise, IDBuilt 1963 · S/N 113 N1242XCarpenter Charles P · Tarzana, CAS/N 115 N1244XLackey Lance Harold · New Braunfels, TXBuilt 1963 · S/N 117 N124JKLewis Fred · Houston, TXBuilt 1966 · S/N 1046 N1251XStephens Donald W · Social Circle, GABuilt 1963 · S/N 124 N1255XThomas Russell Robert · Alhambra, CABuilt 1963 · S/N 128 N1257XGoodman Archie · Mart, TXBuilt 1963 · S/N 130 N1258XCompton Nathaniel Brandon · Fredericksburg, VABuilt 1963 · S/N 131 N1259XSpencer H Brandon · Tampa, FLBuilt 1963 · S/N 132 N1260XCross Paul D · Cowan, TNBuilt 1963 · S/N 133 N1262XHawley Christopher M · Chandler, AZBuilt 1963 · S/N 135 N1264XAnderson Kyle S · Portland, ORBuilt 1963 · S/N 137 N1270XFox Aviation Holdings LLC · Leesburg, INBuilt 1963 · S/N 143 N1272XUrban Norman A · Ray, MIBuilt 1963 · S/N 145 N1277XDuke City Mooney LLC · Lakewood, COBuilt 1963 · S/N 150 N1279XRegistered aircraftBuilt 1963 · S/N 152 N1280XErlandson Michael D · Salt Lake City, UTS/N 153 N1289XConner James B · Mishawaka, INBuilt 1963 · S/N 162 N128ESturges John A · Hayden, IDBuilt 1966 · S/N 1190 N128PBHayes Thomas G · Kerrville, TXBuilt 1966 · S/N 1283 N1290XJr Aviation LLC · Benton, KSBuilt 1963 · S/N 163 N1292XBurns Barry D · Amarillo, TXBuilt 1963 · S/N 165 N1294XMcglynn Brian · Friday Harbor, WABuilt 1963 · S/N 167 N1295XOz Aviation Inc · Cottonwood Falls, KSBuilt 1963 · S/N 168 N1296XFox Judy · Ridgefield, WAS/N 169 N1297XScott Benjamin D · Grove City, OHS/N 170 N12YKinslow Eugene C Jr · Prospect, KYBuilt 1965 · S/N 562 N1300AMann Lee S · Euless, TXBuilt 1966 · S/N 1064 N1303WPowell Steven J · Fairview, TXBuilt 1963 · S/N 191 N1304WBrihn Rhonda J · Waterford, WIBuilt 1963 · S/N 192 N1306W06 Whiskey Partners · Centennial, COBuilt 1963 · S/N 194 N1309WSanford Mark J · Ithaca, NYBuilt 1963 · S/N 197 N130LAInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 21-1175 N1312WKing Scott W · Tampa, FLBuilt 1963 · S/N 200 N1314WNeches Air Inc · Silsbee, TXBuilt 1963 · S/N 202

Back to Mooney M20E