Skip to content

Registered aircraft · 726

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

N7235UWohdet LLC · Farmington, MOBuilt 1985 · S/N TH-1481 N7239RGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N TH-565 N7244RContract Fabricators Inc · Holly Springs, MSBuilt 1975 · S/N TH-558 N7248RHerr Laron · Bristol, SDBuilt 1975 · S/N TH-578 N72521Michigan Aeronautics Commission · Lansing, MIBuilt 1985 · S/N TH-1502 N7253TPyro Shows Inc · La Follette, TNBuilt 1985 · S/N TH-1462 N7254PWildcat Ventures LLC · West Lebanon, NHBuilt 1985 · S/N TH-1504 N7255RZaviation LLC · Fort Smith, ARBuilt 1975 · S/N TH-572 N7258BCff Of New Hampshire Inc · Madison, CTBuilt 1984 · S/N TH-1445 N725HBReel Altitude LLC · Hahira, GABuilt 1996 · S/N TH-1776 N7280RMinus 7 Inc · Durango, COBuilt 1975 · S/N TH-588 N7293RAir New England LLC · Portsmouth, NHBuilt 1975 · S/N TH-590 N72PTInverted Holdings LLC · Newnan, GABuilt 1973 · S/N TH-381 N7302RBurns James P DBA · Plainview, ILBuilt 1974 · S/N TH-472 N7347RN145ta LLC · Carson City, NVBuilt 1974 · S/N TH-482 N7358BHinkle Aviation LLC · Moro, ARS/N TH-373 N735PTwo J Aviation LLC · Lima, OHBuilt 1978 · S/N TH-981 N7379RSunny Skies Inc · Columbus, GABuilt 1974 · S/N TH-512 N7385RCw Aircraft LLC · Atlanta, GABuilt 1976 · S/N TH-734 N738TFester John P · Sullivan, MOS/N TH-706 N746DMBirds Birds LLC · Bradenton, FLS/N TH-354 N747PHFirst State Bancshares Inc · Middleberg, KYBuilt 1988 · S/N TH-1533 N74WMTurnage Leon G · Weatherford, TXBuilt 1975 · S/N TH-653 N757PABmr Financial Inc · Kingston Springs, TNBuilt 1982 · S/N TH-1333 N758CG Daniel Evans P C · Birmingham, ALBuilt 1981 · S/N TH-1275 N758CAAccess Denied Inc · Wilmington, DEBuilt 1978 · S/N TH-1001 N758WPAcr Aircraft LLC · Dover, DEBuilt 1975 · S/N TH-666 N75CLClear LLC · Pierre, SDBuilt 1977 · S/N TH-878 N765CFCs Air LLC · Osage Beach, MOBuilt 1987 · S/N TH-1528 N765WFKofel Aviation LLC · Clayton, GABuilt 1974 · S/N TH-523 N767ARMontenecourt Aviation LLC · Wilmington, DEBuilt 1984 · S/N TH-1407 N767JPPicard Philip A · Clover, SCBuilt 1990 · S/N TH-1583 N76VCBel Air Holdings Inc · Wilmington, DEBuilt 1982 · S/N TH-1361 N770LAGulf Airbatics Ltd · Jennings, LABuilt 1974 · S/N TH-517 N776DADavisair Inc · Raleigh, NCBuilt 1993 · S/N TH-1697 N776WCWingtip Corporation · Valparaiso, INS/N TH-570 N777QAMabry Kelly · Russellville, ARBuilt 1970 · S/N TH-143 N777RABirdsong Michael L · St Simons Island, GABuilt 1981 · S/N TH-1273 N777RQSchelde Brian L · Marble Falls, TXBuilt 1973 · S/N TH-298 N777SGClaw LLC · Lake Saint Louis, MOS/N TH805 N777TKProfessional Paving Services LLC · Macon, GABuilt 1979 · S/N TH-1018 N77LBEleuthera II LLC · Mesa, AZBuilt 1974 · S/N TH-536 N780YPack Larry L · Grand Blanc, MIBuilt 1978 · S/N TH-935 N787CCMegaship Ventures LLC · Baytown, TXBuilt 1985 · S/N TH-1490 N788CF3w Group Inc · Hot Springs, ARBuilt 1977 · S/N TH-870 N789PZWalters Aviation Group LLC · San Diego, CABuilt 1984 · S/N TH-1424 N78DBGreenbrier Aviation LLC · Sevierville, TNBuilt 1980 · S/N TH-1152 N78KLNea Industrial LLC · Paragould, ARBuilt 1990 · S/N TH-1578 N78REKhg Aircraft Inc · Peachtree City, GAS/N TH-371 N78VCBb58 LLC · Greenville, MSBuilt 1995 · S/N TH-1743

Back to Beech 58