Skip to content

Registered aircraft · 121

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

N164DAAv Beech Holding LLC · Mandeville, LABuilt 1966 · S/N MA-101 N1800PRegistered aircraftBuilt 1968 · S/N MA-326 N200AGDively Daniel R · Friedens, PABuilt 1967 · S/N MA-285 N215RCGulf Coast Aviation LLC · New Orleans, LAS/N MA-89 N2324WTolhurst Bruce Clinton · Silver City, NMBuilt 1965 · S/N MA-1 N2373WFayettenam Aero LLC · Laurinburg, NCBuilt 1966 · S/N MA-3 N2399WHudson Shayne · Victorville, CABuilt 1966 · S/N MA-13 N29JRLulafay LLC · Lewes, DES/N MA-235 N30315Registered aircraftBuilt 1968 · S/N MA-313 N31PAUtter Joseph Lynn · Springfield, MOBuilt 1967 · S/N MA-132 N3412CWilson Steve D · Sentinel, OKBuilt 1969 · S/N MA-357 N3601QWard Harry W Trustee · Williamsburg, VABuilt 1967 · S/N MA-226 N3603QWray Development Inc · Menifee, CABuilt 1967 · S/N MA-203 N3607QToole William Barry · Goochland, VABuilt 1967 · S/N MA-207 N3628QJ&B Toys Inc · Wilmington, DEBuilt 1967 · S/N MA-213 N3630QStar Aviation LLC · Mauston, WIBuilt 1967 · S/N MA-225 N3648QRegistration Pending · Graham, WARegistration pendingBuilt 1967 · S/N MA-233 N3649QSteinberg Stephen M · Happy Valley, ORBuilt 1967 · S/N MA-234 N3652QNolen David S · Wimberley, TXBuilt 1967 · S/N MA-239 N3653QFlying Naked Muskteers LLC · Palm City, FLBuilt 1967 · S/N MA-240 N3661QLong Nathan J · Huntsburg, OHS/N MA-251 N3664QDiana Scott J · Wallingford, CTBuilt 1967 · S/N MA-249 N3666QHighum Peter · Hernando Beach, FLBuilt 1967 · S/N MA-253 N3667QLife'S A Beech LLC · Wilmington, DEBuilt 1967 · S/N MA-269 N3668QPaul B Meadowbrook Pc · Albany, ORS/N MA-255 N3669QMarshall Jerry W · Centennial, COBuilt 1967 · S/N MA-256 N3672QDye Laura G · Whispering Pines, NCBuilt 1967 · S/N MA-262 N3675QSwann Phyllis R · Madison, ALBuilt 1967 · S/N MA-266 N3676QJobe Eric J · Parkville, MOBuilt 1967 · S/N MA-267 N3685QEaston Bryan L · Council Bluffs, IAS/N MA-259 N3687QHjelle Tim D · Malone, WIBuilt 1967 · S/N MA-270 N3688QFour Musketeers LLC · Wichita, KSBuilt 1967 · S/N MA-272 N3689QBusick Aviation LLC · England, ARBuilt 1967 · S/N MA-271 N3691QKempf David V · San Tan Valley, AZS/N MA-276 N3698QGribble David A · Marion, IABuilt 1967 · S/N MA-281 N3699QHillner Kevin D · Marengo, ILS/N MA-282 N469JSToole William B · Goochland, VABuilt 1966 · S/N MA-23 N4707JBeck Joseph P II · Pollock, LABuilt 1966 · S/N MA-147 N4726JPurves Patrick W · Brooklyn Park, MNBuilt 1966 · S/N MA-158 N4731JLandon Jeff · Quartz Hill, CAS/N MA-169 N4732JN500tj LLC · Middletown, DEBuilt 1967 · S/N MA-170 N4734JGeurink Jonathan E · Hudsonville, MIBuilt 1967 · S/N MA-172 N4736JOliver Darrin C · Ripley, OKBuilt 1967 · S/N MA-189 N4738JChamberlain Kathleen A · Apache Junction, AZBuilt 1967 · S/N MA-176 N4758JFardell Christopher J · Gilbert, AZBuilt 1967 · S/N MA-186 N4759JPersons Jonathan B · Eagan, MNBuilt 1967 · S/N MA-187 N4774JAlbin John B · Milan, MIBuilt 1967 · S/N MA-192 N4789JChenault Mitchell Ray · Renton, WABuilt 1967 · S/N MA-209 N4793JSheco Inc · Aloha, ORBuilt 1967 · S/N MA-199 N4TC14tz LLC · Geneva, FLBuilt 1966 · S/N MA-9

Back to Beech A23-24