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.

N1013PSentinel Services Group LLC · Brooksville, FLS/N MC-428 N103RGTupelo Aeronautics Inc · Tupelo, MSBuilt 1975 · S/N MC358 N104DBPryce Gerald · Independence, ORBuilt 1974 · S/N MC-309 N1929LIngstad Eric Charles · Lakewood, CABuilt 1976 · S/N MC-416 N1933LN1933l Ltd · Streetsboro, OHBuilt 1976 · S/N MC-417 N1937LLuks George J · Crescent City, CABuilt 1976 · S/N MC-419 N1938LTexas Environmental Training & Compliance LLC · Frost, TXBuilt 1976 · S/N MC-414 N1939LCook Kenneth T · Danielson, CTBuilt 1976 · S/N MC-418 N1942LN1942l LLC · Wichita, KSBuilt 1976 · S/N MC-415 N1953LWyatt Shawn D · Fort Worth, TXBuilt 1976 · S/N MC-421 N1957LSmith Joseph M · Ames, IABuilt 1976 · S/N MC-423 N1960LButler David · Palos Park, ILBuilt 1976 · S/N MC-422 N1991LHarvatine Francis J · Sykesville, MDBuilt 1976 · S/N MC-431 N2044LLeitner Jay T · Hurst, TXBuilt 1976 · S/N MC-440 N2046LHemby Clint L · Bonham, TXBuilt 1976 · S/N MC-433 N2051LParker Joyce A · Topeka, KSBuilt 1976 · S/N MC-436 N2056LHodges Fred Lloyd Jr · Ellabell, GABuilt 1976 · S/N MC-435 N2165WHarrison Dan H · Englewood, FLBuilt 1974 · S/N MC252 N2188WMccrea Justin M · Big Spring, TXS/N MC-258 N2210LStefanov Mark · Georgetown, TXBuilt 1976 · S/N MC-441 N2212LVorel Jeffrey A · Longboat Key, FLBuilt 1976 · S/N MC-442 N2220LLegitimate Business LLC · Las Vegas, NVS/N MC-445 N22PALubo Aviation LLC · Gastonia, NCBuilt 1974 · S/N MC-223 N23PDHigh Sierra Flying LLC · Incline Village, NVBuilt 1976 · S/N MC-408 N24588Fischer Paul O · Great Falls, MTS/N MC-157 N24672Gurgainous Larry K · Fredericksburg, VABuilt 1973 · S/N MC-154 N24PDRobertson Chad W · Hubbard, ORBuilt 1976 · S/N MC-411 N24PQBlackburn Joseph E Jr · Richmond, VABuilt 1974 · S/N MC-227 N2501WSolari Peter L · Lebanon, CTBuilt 1973 · S/N MC-155 N2506WHeiss William R · Watkins, COS/N MC-165 N2507WHoffman Ray Y · Elysburg, PARegistration revokedBuilt 1973 · S/N MC-190 N2508WBas Part Sales LLC · Greeley, COS/N MC-166 N2511WArcher Ht LLC · Noblesville, INBuilt 1973 · S/N MC-172 N2512WMonroe Judy L · Keller, TXBuilt 1973 · S/N MC-174 N2513WDaniel Raymond C III · Newborn, GABuilt 1973 · S/N MC-171 N2514WFalandys David L · Port Orange, FLBuilt 1973 · S/N MC-178 N2515WRegistered aircraftS/N MC-187 N2516W4 C'S Aviation LLC · Larose, LABuilt 1973 · S/N MC-188 N2519WWilliam Rainey Harper College District 512 · Palatine, ILS/N MC-194 N2524WAerowave Aviation LLC · Noblesville, INBuilt 1973 · S/N MC-196 N2532WFrontier Flyers LLC · Anchorage, AKBuilt 1974 · S/N MC-207 N2533WH&A Aircraft Services LLC · Omaha, ARBuilt 1973 · S/N MC-208 N2534WFreds Legacy LLC · Chagrin Falls, OHBuilt 1974 · S/N MC-214 N2538WBeach Eric J · Middletown, NYBuilt 1974 · S/N MC-215 N2539WZavala David · Demorest, GABuilt 1974 · S/N MC-219 N2545WRegistration Pending · Vienna, OHRegistration pendingBuilt 1974 · S/N MC-242 N2547WBittorf Charles Shane · Clear Lake, WIBuilt 1974 · S/N MC-255 N2548WGotschall Harry A · San Antonio, TXBuilt 1974 · S/N MC-257 N283GWend Roger W · Charlotte, MIBuilt 1974 · S/N MC-241 N39TASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N MC-230

Back to Beech B24R