Skip to content

Registered aircraft · 1,258

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

N5919QBig Sky Adventures LLC · Nicholasville, KYS/N 3168 N5933QDonaldson Lucas P · Owyhee, NVS/N 3177 N5936QEllis Robert L · Columbus, OHBuilt 1965 · S/N 3180 N5937QPospicil John A · Huntsville, ALBuilt 1965 · S/N 3181 N5943QFreeborn Andrew B · North Las Vegas, NVBuilt 1965 · S/N 3187 N5947QMorales Nelson · Hendersonville, NCBuilt 1965 · S/N 3189 N5948QKrull Lynn · Thompson, IAS/N 3190 N5953QRoberts Stephen C · San Marcos, TXBuilt 1965 · S/N 3193 N5954QDominique Jon Andrew · Lenoir, NCBuilt 1965 · S/N 3194 N5956QHunt Brian A · Alexandria, VAS/N 3195 N5960QPlett Leo V · Liberal, KSBuilt 1965 · S/N 3197 N5963QKatz Matthew · Los Angeles, CABuilt 1965 · S/N 3199 N5964QLin Andrew Hsia · Huntingtown, MDBuilt 1965 · S/N 3200 N5968QChess House LLC · Canton, SDS/N 3202 N5970QYeager Robert Allen · Oregon City, ORBuilt 1965 · S/N 3203 N5974QTaylor Timothy T · Quitman, ARFirst renewal noticeBuilt 1965 · S/N 3205 N5978QBauer Jared R · Sugar City, COBuilt 1965 · S/N 3208 N5984QSlow Walkin Barnstormers LLC · Frostproof, FLBuilt 1965 · S/N 3211 N5985QInderkummen Jean Pierre · Gulfport, MSFirst renewal noticeBuilt 1965 · S/N 3212 N5988QLynn Seth D · Killeen, TXS/N 3213 N5989QPressley Brent DBA · Morristown, TNS/N 3214 N5991QBain Douglas D · Vega, TXBuilt 1966 · S/N 3215 N5992QFriday Ryan M · Elizabeth, PABuilt 1965 · S/N 3216 N5995QFangmeier Benjamin A · Strasburg, COBuilt 1965 · S/N 3217 N59BJWalser Air LLC · Warwick, RIBuilt 1965 · S/N 2968 N5MDDunn Vincent K · Salem, ORBuilt 1966 · S/N 3317 N6000QInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 3221 N6001QCurry Gary · Everett, WABuilt 1965 · S/N 3222 N6003QOsborn John W · Cimarron, KSBuilt 1965 · S/N 3223 N6004QSmith Aviation Inc · Wilmington, DEBuilt 1965 · S/N 3224 N6007QRegistration Pending · Tampa, FLRegistration pendingBuilt 1965 · S/N 3225 N6020QN6020q LLC · Jensen Beach, FLBuilt 1965 · S/N 3231 N6021QR&L Aviation Inc · Philadelphia, PAS/N 3232 N6026QKosmata Charles C · Mcpherson, KSBuilt 1965 · S/N 3234 N6029QHill John T · Saint Augustine, FLBuilt 1965 · S/N 3235 N6034QBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 3237 N6035QWylie Warren J · Montague, NJS/N 3238 N6039QEagar Mark A · Cameron Park, CABuilt 1965 · S/N 3239 N6044QOliver Nicholas R · Arroyo Grande, CABuilt 1965 · S/N 3241 N6049QBudgett Stephen A · Gilbert, AZBuilt 1965 · S/N 3243 N6055QGlenn Howard Anderson Jr · Wakefield, RIBuilt 1965 · S/N 3246 N6059QSchoenleben Thomas J · Stevensville, MTBuilt 1965 · S/N 3247 N6064QWilliams Rodney K · Stacy, MNBuilt 1965 · S/N 3249 N6065QShick Douglas Todd · Chester, VAS/N 3250 N606WLarson Bernard J · Mt Vernon, WABuilt 1965 · S/N 3172 N6070QOdenbach Eric J · Eureka, SDBuilt 1966 · S/N 3328 N6074QMiranda Edward G · Prescott Valley, AZBuilt 1965 · S/N 3253 N6084QHammond Edward M · Grass Valley, CABuilt 1965 · S/N 3257 N6089QMolnar Victor · Ballston Spa, NYBuilt 1965 · S/N 3259 N6094QRakes Bobby N Jr · Saint Robert, MOBuilt 1965 · S/N 3261

Back to Mooney M20C