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.

N6929UEisenhardt Scott · Milwaukee, WIBuilt 1964 · S/N 299 N6931UMascagni Jerry Scott · Greenville, MSBuilt 1964 · S/N 301 N6932UHeming Robert C · Overgaard, AZBuilt 1964 · S/N 302 N6933UMach 4 Missions Inc · Middleton, TNS/N 303 N6934UWydronek Marcus G · Goodyear, AZS/N 304 N6940UNewby Adam M · Anchor Point, AKS/N 310 N6941UBukac Glenn P · Villa Park, ILBuilt 1964 · S/N 311 N6945UGipe Douglas A · Malvern, IABuilt 1964 · S/N 315 N6949ULambert Donald H · Westwood, MABuilt 1964 · S/N 319 N6952UDuggan Edwin T · Franklin, MEFirst renewal noticeBuilt 1964 · S/N 322 N695PMSimonson Robert J · Cedar Crest, NMBuilt 1966 · S/N 1021 N6964ULara Anthony · Manitou Springs, COBuilt 1964 · S/N 324 N6966UUnderhill Robert A · Redding, CABuilt 1964 · S/N 326 N6967UEstey Richard H · Thomson, GABuilt 1964 · S/N 327 N6968UFowler Craig A · Chireno, TXBuilt 1964 · S/N 328 N6969UBurdak Erik · Mound, MNBuilt 1964 · S/N 329 N6970UCampbell Steven D · Henderson, NVBuilt 1964 · S/N 330 N6971UStephen Jacoby A · Coconut Creek, FLS/N 331 N6972UAyres Floyd Dean · Leavenworth, KSBuilt 1964 · S/N 422 N6975UBallou-Crawford Terry · Savannah, MOBuilt 1964 · S/N 335 N6976UHumble Enterprises Inc · Valley Head, ALBuilt 1964 · S/N 336 N6977UPoss Alexander C · Del Rio, TXBuilt 1964 · S/N 337 N6978UDouglass Rick C · Bakersfield, CABuilt 1964 · S/N 338 N6979UGiles Forrest D · Springtown, TXBuilt 1964 · S/N 339 N6980UHarvard Air Taxi LLC · Andover, MABuilt 1964 · S/N 340 N6982UStanley Harrelson Mccall · Pepperell, MABuilt 1964 · S/N 342 N6986UNabors Ricky D · Valrico, FLBuilt 1964 · S/N 346 N6988UKisthard James A · Roberts, MTBuilt 1964 · S/N 348 N6991UHochstein Scott J · Skiatook, OKBuilt 1964 · S/N 351 N6993URamirez Arturo A · Lake Creek, TXBuilt 1964 · S/N 353 N706CFRegistered aircraftBuilt 1963 · S/N 127 N706WCChilcott Bart L · Derby, KSBuilt 1965 · S/N 647 N7105VCromwell James T · Hamilton, MTBuilt 1974 · S/N 21-0039 N7106VMcatee Von · Houston, TXBuilt 1974 · S/N 21-0040 N7114UMaximizing Abilities Through Training Two DBA · Independence, MOBuilt 1964 · S/N 356 N7119VMark Youngblood Pa · Naples, FLBuilt 1974 · S/N 21-0042 N7120VOpulent Investments LLC · Mandan, NDBuilt 1974 · S/N 21-0043 N7124UGoss Brendan · Shady Shores, TXS/N 363 N7125UTakacs Robert S · Oxford, CTBuilt 1964 · S/N 364 N7134UDalton James D · Pasadena, TXBuilt 1964 · S/N 373 N7136VHickman Jared · Bothell, WABuilt 1974 · S/N 21-0045 N7137UMalone David V · Oklahoma City, OKBuilt 1964 · S/N 376 N7137VZelek Daniel · Wurtsboro, NYBuilt 1974 · S/N 21-0046 N7138UHinkle Robert J · Caldwell, IDBuilt 1964 · S/N 377 N7138VColombo Brian M · Oswego, NYBuilt 1974 · S/N 21-0047 N7139UMott Charles A Jr · Chesapeake, VAS/N 378 N7140VVallejo Noel R · Alpine, UTFirst renewal noticeBuilt 1974 · S/N 21-0049 N7141UBlazevic Bojan · Las Vegas, NVBuilt 1964 · S/N 380 N7142UBykowsky Eric · Atlanta, GABuilt 1964 · S/N 381 N7147UCurtin Matthew T · Cedar Hills, UTBuilt 1964 · S/N 386

Back to Mooney M20E