Skip to content

Registered aircraft · 117

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

N4341WBarlow Steven J · Mansfield, OHBuilt 1974 · S/N MC-270 N4343WRhodes Stephen D · Hendersonville, NCBuilt 1974 · S/N MC-264 N4350WHochbrueckner Timothy W · Mineola, NYBuilt 1974 · S/N MC-272 N4355WFrieson Steven B · Claremont, CABuilt 1974 · S/N MC-271 N508MARms Beach Sierra LLC · Brownsville, TXBuilt 1975 · S/N MC-318 N53EMChecker Aircraft LLC · Wilmington, DEBuilt 1976 · S/N MC-395 N64840Carter Thomas E · Ocala, FLBuilt 1982 · S/N MC-781 N6502RSmith Duane · Felt, OKBuilt 1974 · S/N MC-259 N6558RAntonucci Donald · Barkhamsted, CTBuilt 1974 · S/N MC-294 N6564RKuertz Enterprise Ltd · Wilmington, DEBuilt 1974 · S/N MC-301 N6565RAldarondo Luis A · Corvallis, ORBuilt 1974 · S/N MC-302 N6569RMartin Brewster D · Saint Clairsville, OHBuilt 1974 · S/N MC-299 N6570RBellas Business LLC · Kalispell, MTBuilt 1974 · S/N MC-298 N6581RMyrtle Beach Dustless Blasting Llp · Loris, SCBuilt 1975 · S/N MC-303 N6582RFca Flight Training And Aircraft Maintenance Inc · Wshngtn Ct Hs, OHBuilt 1974 · S/N MC-304 N6588RAugust Aero LLC · Kalispell, MTBuilt 1974 · S/N MC-251 N6592RSchmidt Louis J · Orange, CABuilt 1974 · S/N MC-308 N6613RPollazzi Steven N · New Hope, PABuilt 1974 · S/N MC-312 N6630RGamma2 Inc · San Diego, CABuilt 1974 · S/N MC-314 N6631RCornelius Craig R · West Hartford, CTBuilt 1974 · S/N MC-313 N6950RJefferson Airplane LLC · Port Hadlock, WABuilt 1975 · S/N MC-315 N6952RMelville Isaiah · Panama City, FLBuilt 1975 · S/N MC-317 N6956RMorgan Richard D · Belton, TXBuilt 1975 · S/N MC-320 N6972RWhite Robert Graydon · Damascus, ORBuilt 1976 · S/N MC-323 N6978RDodson International Parts Inc · Rantoul, KSS/N MC-324 N6980RRock Your Wings LLC · Litchfield, OHBuilt 1975 · S/N MC-325 N6985RWard Chad E · Paducah, KYBuilt 1975 · S/N MC-326 N6989RMoran Dennis E · Waverly, PABuilt 1975 · S/N MC-331 N6992RBanana River Aviation LLC · Merritt Island, FLBuilt 1975 · S/N MC-328 N7117EDowell Cameron C · Solomons, MDBuilt 1974 · S/N MC-278 N76PTMcmurtrey Michael · Farmington, MNBuilt 1974 · S/N MC228 N87140Cgl Media LLC · Jupiter, FLBuilt 1975 · S/N MC-335 N9143SBooton Charles E · Navarre, FLBuilt 1975 · S/N MC-397 N9152SHomer Mark · Grosse Ile, MIBuilt 1975 · S/N MC-399 N9153SB Squared Inc · Bedford, NHBuilt 1976 · S/N MC-400 N9156SStickley Harold R · Wauseon, OHBuilt 1976 · S/N MC-401 N9164SGreat Planes Flyers LLC · Mccook, NEBuilt 1976 · S/N MC-403 N9178SSwoboda Kristin · Boise, IDBuilt 1976 · S/N MC-406 N9193SMiller Brian P · Middletown, INBuilt 1975 · S/N MC-365 N9195SBailey Thomas P · Cannelton, INBuilt 1975 · S/N MC-368 N9196SSkyward Leasing Inc · Dallas, GABuilt 1975 · S/N MC-370 N9204SHoward Alexander James · Coulterville, ILS/N MC-374 N9206SJohnson W Norman · Stayton, ORS/N MC-375 N9207SMr Woodchuck LLC · Naples, FLBuilt 1975 · S/N MC-376 N9210SBazemore Dennis A · Ingleside, TXBuilt 1975 · S/N MC-384 N9220SWard Jessica · Southport, NCBuilt 1975 · S/N MC-380 N9251SAayan Air LLC · Westfield, MABuilt 1975 · S/N MC-387 N9259SAlles Harry · Greeley, COBuilt 1975 · S/N MC-389 N9270SVinson Raymond R III · Mckinney, TXBuilt 1975 · S/N MC-392 N9284STamad Aviation LLC · Tracy, CABuilt 1975 · S/N MC-329

Back to Beech B24R