Skip to content

Registered aircraft · 144

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

N6532QValley River Leasing Inc · Murphy, NCBuilt 1966 · S/N A-132 N6534QGregory Vernon L · Swansea, SCBuilt 1966 · S/N A-134 N6537QGoodwin Greg J · Cleveland, TXBuilt 1966 · S/N A-137 N6538QShaw Monte L · Hillsboro, OHS/N A-138 N6539QMcginnis Louis F · Raton, NMBuilt 1966 · S/N A-139 N6543QAnderson Kenneth J · Norman, OKBuilt 1966 · S/N A-143 N6544QRush Paul E · Highland, KSBuilt 1966 · S/N A-144 N6545QRegistered aircraftBuilt 1966 · S/N A-145 N6547QOwen Mark L · Clyde, TXBuilt 1966 · S/N A-147 N6548QBuenger Sam · Seabrook, TXBuilt 1966 · S/N A-148 N6549QRoman Luis M · Miami, FLBuilt 1966 · S/N A-149 N6550QMarden Michele · Erwinna, PABuilt 1966 · S/N A-150 N6551QFitzhenry Thomas M · Richfield, MNBuilt 1966 · S/N A-151 N6555QGabbert Douglas S · Palm Coast, FLBuilt 1965 · S/N A-55 N6556QGabrail Peter S · Greer, SCBuilt 1965 · S/N A-56 N6557QLee Jan · Sandpoint, IDBuilt 1965 · S/N A-57 N6558QDelgado Joaquin C Jr · Kingwood, TXBuilt 1965 · S/N A-58 N6559QWest Alert Security Services Inc · Clearlake Park, CABuilt 1965 · S/N A-59 N6564QGrimes James Rex · Carlton, GABuilt 1965 · S/N A-64 N6565QBeicker Dennie L · Hernando, MSBuilt 1965 · S/N A-65 N6566QGregoire Norris Scott · Walla Walla, WABuilt 1965 · S/N A-66 N6567QPhillips Raymond B · Inver Grove, MNS/N A-67 N6568QLaliberte George A Trustee · Topeka, KSBuilt 1965 · S/N A-68 N6569QWiddows Michael J · Thousand Oaks, CABuilt 1965 · S/N A-69 N6570QAviation Training Inc · Cameron Park, CAS/N A-70 N6571QKarpov Andre W · Newark, DES/N A71 N6572QCarlton Davis E · Grove, OKS/N A-72 N6573QHolcomb Gene · Memphis, TNS/N A-73 N6576QGeisen Timothy L · San Pedro, CABuilt 1965 · S/N A-76 N6579QMonske Nicholas J · Austin, TXBuilt 1965 · S/N A-79 N6580QThomas Dale A · Gooding, IDBuilt 1965 · S/N A-80 N6581QBachman Ernest J · New Brighton, PABuilt 1965 · S/N A-81 N6583QBernstein Matthew D · North Charleston, SCBuilt 1966 · S/N A-83 N6585QJones Steve · Torrance, CABuilt 1965 · S/N A-85 N6594QFantasy Fighters Inc · Santa Fe, NMBuilt 1966 · S/N A-94 N6596QAsk42 Ltd · Stary DebiecBuilt 1966 · S/N A-96 N6598QMcdonnell David · Belle Plaine, KSBuilt 1966 · S/N A-98 N65GMSalmonson Stefan Virgil · Mora, MNBuilt 1965 · S/N A-53 N75RD75rd LLC · Moraine, OHS/N A-93 N767WRHangar R LLC · Irvington, ALBuilt 1966 · S/N A-133 N7771JSchumann Jay W · Hampton, IAS/N A-27 N800PYBigge George F Jr · Pittsgrove, NJBuilt 1966 · S/N A-162 N825DCMcdaniel Ronnie J Sr · Starkville, MSBuilt 1966 · S/N A-124 N919WQStone Jeffrey · Fort Collins, COBuilt 1966 · S/N A-107

Back to Alon A2