Skip to content

Registered aircraft · 721

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

N4224NPeterson Dominic S · Los Alamos, NMBuilt 1974 · S/N 220065 N432AEArnold Neil · Caro, MIBuilt 1968 · S/N 690019 N441WSFord Mark L · New Cambria, KSBuilt 1966 · S/N 670049 N444DSLatitude Air Inc · Port Orange, FLBuilt 1975 · S/N 22-1221 N44ABAnthony Ronald W · Claremont, CABuilt 1975 · S/N 22-1196 N46ECHermans Greg · Virginia Beach, VABuilt 1975 · S/N 22-1218 N477TPaetzold Benjamin T · Fort Worth, TXBuilt 1967 · S/N 670274 N4875DNightwing Productions LLC · Aptos, CABuilt 1967 · S/N 670218 N4LDMartin Matthew · Austin, TXBuilt 1967 · S/N 670318 N5000FAareyn LLC · Merritt Island, FLBuilt 1976 · S/N 22-1363 N5000LTrobaugh Michael A · Highland, ILBuilt 1968 · S/N 690017 N514MLPikes Private Planes LLC · Danville, KYBuilt 1968 · S/N 680178 N528CSCarlton David C · Carlsbad, CABuilt 1967 · S/N 670429 N528WFSchwan Steven R · Parker, COS/N 670433 N52DBSmith Terry · Cedar Hill, TNS/N 22-1399 N532DBell Marvin III · Mansfield, TXBuilt 1968 · S/N 680143 N5365GKlaw-N5365g LLC · Lawton, OKBuilt 1974 · S/N 22-0071 N555DYCaptain'S Quarters Marina & Storage Inc · Johnson Lake, NEBuilt 1966 · S/N 670055 N555GCSasakwa LLC · Pittsfield, MABuilt 1967 · S/N 670508 N591PHKingdom Air Corps · Sutton, AKBuilt 1966 · S/N 670041 N595VNess David A · Minneapolis, MNBuilt 1966 · S/N 670206 N600FSHome Free Aviation LLC · New Port Richey, FLBuilt 1974 · S/N 22-0044 N605JTKiefer Matthew J · Xenia, OHBuilt 1974 · S/N 22-0039 N621LTWood Austin F · Seattle, WABuilt 1974 · S/N 22-0064 N6301QJenny Steven R · Boise, IDBuilt 1967 · S/N 670394 N6302QMerritt Chad William · Hillsborough, NCBuilt 1967 · S/N 670395 N6303QCoker Steve L Jr · Tyler, TXBuilt 1967 · S/N 670396 N6304QN6304q LLC · Berthoud, COBuilt 1967 · S/N 670397 N6306QMaxwell Paul · Longview, TXBuilt 1967 · S/N 670399 N6309QRegistered aircraftBuilt 1967 · S/N 670402 N6312QBarker Silas J · Sanford, FLBuilt 1967 · S/N 670405 N6316QRegistered aircraftBuilt 1967 · S/N 670409 N6319QEllis Jacob · El Reno, OKBuilt 1967 · S/N 670412 N631KYHanson Anthony R · Ozark, ALBuilt 1967 · S/N 670406 N6321QDonesky Orville B · Cleveland, TNBuilt 1967 · S/N 670414 N6324QTymoshenko Yuriy · Clearwater, FLBuilt 1967 · S/N 670417 N6336QGeco Inc · Wilmington, DEBuilt 1967 · S/N 670419 N6337QMariette Robert K · Happy Camp, CABuilt 1967 · S/N 670420 N6338QTikhonov Andrey V · Chino, CABuilt 1967 · S/N 670421 N6339QVidoni Richard G · Hagerstown, MDBuilt 1967 · S/N 670422 N6341QSanderson Shawn · Chelan, WAS/N 670424 N6343QWindsock Aviation LLC · Edmond, OKBuilt 1967 · S/N 670426 N6344QSoseman Christian James · Maricopa, AZBuilt 1967 · S/N 670427 N6345QPerry Edward Glen Trustee · Ozark, ARBuilt 1967 · S/N 670428 N6348QMartin Chadwick P · Palm Harbor, FLBuilt 1967 · S/N 670431 N6351QRegistered aircraftBuilt 1967 · S/N 670434 N6354QSibley Kevin W · Porter, TXBuilt 1967 · S/N 670437 N6355QEinck John J · Stockton, ILBuilt 1967 · S/N 670438 N6356QKline Larry C · Fountain Hills, AZBuilt 1967 · S/N 670439 N6358QBibb Kenneth · Sayre, OKBuilt 1967 · S/N 670443

Back to Mooney M20F