Skip to content

Registered aircraft · 52

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

N125CMaitland David L · Culpeper, VABuilt 1950 · S/N 205 N18CTAugustin Lyn H · Saint Thomas, NDBuilt 1953 · S/N 287 N223VSheppard Alan J · Onamia, MNS/N 223 N283DEMccrath Michael E · Seattle, WABuilt 1953 · S/N 283 N325MMandibles Edward Jr · Lompoc, CABuilt 1950 · S/N 206 N335MCabbage David A · Colville, WABuilt 1950 · S/N 216 N339MGagne Gilbert R · Apple Valley, CABuilt 1950 · S/N 220 N342MEtling Kurt Karl · Edgewood, TXBuilt 1950 · S/N 222 N344MAxford Dwayne E · Wheatland, WYBuilt 1950 · S/N 224 N346MLester Stephen P · New Smyrna Beach, FLS/N 226 N4057Dix Walter R Jr · Winter Haven, FLBuilt 1951 · S/N 249 N4065Hughes Roger L · Corpus Christi, TXBuilt 1952 · S/N 255 N4068Lovley Forrest T · Jordan, MNBuilt 1952 · S/N 258 N4070Dodson David W · Granger, INBuilt 1952 · S/N 260 N4073Fritz David C · Lincoln, NEBuilt 1952 · S/N 261 N4075VNiva Gary W · Monte Sereno, CABuilt 1952 · S/N 262 N4076Morgan Jeff P · Justin, TXS/N 263 N4078Loffert George U Jr · Killeen, TXBuilt 1952 · S/N 264 N4094Kopec Craig W · Long Beach, CABuilt 1952 · S/N 271 N4095Jenkins James L · Lake Stevens, WAS/N 272 N4096Lewis Scott C · Los Angeles, CABuilt 1952 · S/N 273 N4101Connolly Luke A · Blaine, MNS/N 276 N4118White Brian R · Concrete, WABuilt 1953 · S/N 286 N4121Lee Jonathan Ce · Bossier City, LABuilt 1953 · S/N 288 N4122Parrott Matthew E · New Carlisle, OHS/N 290 N4123King Ernest W III · Uvalde, TXS/N 291 N4124Johnston Joel D · Mead, WABuilt 1953 · S/N 293 N4126Davenport Jimmy J · Hayesville, NCBuilt 1953 · S/N 296 N4130Southard Brian K · Las Cruces, NMBuilt 1953 · S/N 301 N4132Teeter Joseph Jerald · Lisbon, OHBuilt 1953 · S/N 302 N4138Engelskirger Karl D · Valley City, OHBuilt 1954 · S/N 305 N4142Ranger Airfield Foundation · Ranger, TXBuilt 1954 · S/N 308 N4143Davenport Jimmy J · Hayesville, NCBuilt 1954 · S/N 309 N4148Dillen William M · Fairview, PAS/N 314 N4149EMay Richard U · Corvallis, ORBuilt 1954 · S/N 315 N4150Jordan Ronald · Stoutsville, OHBuilt 1954 · S/N 316 N4152Mountain Air Inc · Quincy, CABuilt 1954 · S/N 318 N4154Jenkins Robert G Jr · Plainville, GABuilt 1955 · S/N 320 N4155Lovett Cole J · Giddings, TXBuilt 1955 · S/N 321 N4161Plyler Aviation Lp · Sherman, TXBuilt 1955 · S/N 327 N4177Garner David K · Auburn, WABuilt 1955 · S/N 342 N4178N4178 LLC · Palmer, AKBuilt 1956 · S/N 343 N478MBachman Mildred R · New Brighton, PABuilt 1950 · S/N 233 N485MSahagun Salvador G · Bothell, WABuilt 1950 · S/N 239 N486MBrunhoeber Mike E · Caldwell, KSS/N 240 N491MThompson Michael P · Natchez, MSBuilt 1951 · S/N 244 N492MKansas Aviation Museum · Wichita, KSBuilt 1951 · S/N 245 N496MBc Enterprises Of Salina LLC · Salina, KSBuilt 1951 · S/N 246 N4EMEberhardy John F · Radisson, WIBuilt 1953 · S/N 299 N70DVAnderstedt Richard Allan · Clearwater, MNBuilt 1950 · S/N 218

Back to Mooney M-18C