Skip to content

Registered aircraft · 176

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

N118GBBas Part Sales LLC · Greeley, COS/N MC-582 N1820GGarcia Ted A · Carefree, AZBuilt 1981 · S/N MC-702 N1824PHoffman Warren S · East Meadow, NYBuilt 1981 · S/N MC-759 N1824XKepo Aviation LLC · Ball, LABuilt 1981 · S/N MC-760 N1827ZGray Amber · Forestville, CABuilt 1981 · S/N MC-762 N1831NMargegrace17 LLC · Dayt Bch Sh, FLBuilt 1981 · S/N MC-763 N18372N18372 LLC · Kalispell, MTBuilt 1981 · S/N MC-764 N18767Zimmerman Patrick Joseph · Roseburg, ORBuilt 1977 · S/N MC-503 N18769Shiel Penny S · Palisade, COBuilt 1977 · S/N MC-500 N18770Robinson Jere L · Burnet, TXS/N MC-498 N18782Stagman Andrew A · Land O Lakes, FLBuilt 1977 · S/N MC-505 N18793Berns Robert D · Clifton, ILBuilt 1977 · S/N MC-506 N18798Herald Jason E · Tulsa, OKBuilt 1977 · S/N MC-508 N18841Quality Aviation Inc · Atlanta, GABuilt 1977 · S/N MC-509 N18858Martindale Ian C · Seattle, WABuilt 1977 · S/N MC-510 N18859Molnair LLC · Columbus, GABuilt 1977 · S/N MC-511 N18865Shoreline Aviation LLC · Norman, OKBuilt 1977 · S/N MC-514 N18874Registration Pending · Pantego, NCRegistration pendingBuilt 1977 · S/N MC-518 N18887Clifford Royce Ellen · Leucadia, CABuilt 1977 · S/N MC-519 N18909Thomas William Tyler · Athens, TNBuilt 1977 · S/N MC-524 N18930Trustgroup Aircraft Hangar Sales LLC · Metairie, LABuilt 1977 · S/N MC-527 N18934Gray Van D · Woodway, TXBuilt 1977 · S/N MC-530 N18938Hangar 5 LLC · Williamsburg, VABuilt 1977 · S/N MC-531 N18940Mella Aviation LLC · Tucson, AZBuilt 1977 · S/N MC-532 N18950Osgood James G · Columbia, MOBuilt 1977 · S/N MC-535 N18951Evans Lynn · Vici, OKBuilt 1977 · S/N MC-536 N18959Rushton Damion · Ellenwood, GABuilt 1977 · S/N MC-539 N18974Carbon County Oncology Management Inc · Auburn, PABuilt 1977 · S/N MC-542 N18981K V Aviation Ltd · Greenfield, INBuilt 1977 · S/N MC-545 N18987Bhr Aviation Inc · Potomac, MDBuilt 1979 · S/N MC-546 N18993Ochs Mark A · Madison, MSBuilt 1977 · S/N MC-550 N18996Black Bennett · Hansville, SCBuilt 1977 · S/N MC-553 N2007GRibeiro Carlos E · Vail, AZBuilt 1978 · S/N MC-592 N2008BBrown William Tim · Ozark, MOBuilt 1978 · S/N MC-596 N2008ZSouthern Wings Aircraft Sales Ltd · Bethany, OKBuilt 1978 · S/N MC-597 N2009KMann Terry S · Farmerville, LABuilt 1978 · S/N MC-591 N2009TConcho Valley Flyers LLC · Denton, TXS/N MC-598 N2009URothe Danny L · Pawnee, ILBuilt 1978 · S/N MC-595 N20119Euroaviation Inc Trustee · KematenS/N MC602 N2012ATownsend Brooks P · Hattiesburg, MSBuilt 1978 · S/N MC-599 N2014GReich Gary J Trustee · Chippewa Falls, WIBuilt 1978 · S/N MC-606 N20754Sweet Scott A · Naples, FLBuilt 1978 · S/N MC-615 N2075AJacobs Nathan G · North Swanzey, NHBuilt 1978 · S/N MC-610 N2075EStateline Aviation Inc · Dover, DEBuilt 1978 · S/N MC-612 N2075XMehling Michael · Parish, NYBuilt 1978 · S/N MC-614 N212STWalsh Scott · Stuart, FLBuilt 1978 · S/N MC-566 N2225LBratcher Randy L · Saint Charles, MOBuilt 1977 · S/N MC-449 N2238LDeris Jeffrey J · Madison, MSBuilt 1976 · S/N MC-459 N2244LDerivan Theodore S · Bremen, MEBuilt 1976 · S/N MC-458 N2253LFisher Robert C · Shepherdstown, WVBuilt 1976 · S/N MC-453

Back to Beech C24R