Skip to content

Registered aircraft · 115

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

N355SDBofus Aviation LLC · Helena, MTBuilt 2007 · S/N S1907 N3624TMaxess Inc · Thonotosassa, FLBuilt 1984 · S/N S1173 N3625TBlade Runners Chopper LLC · Sunbury, OHBuilt 1989 · S/N S1396 N366GCHavens Aviation LLC · Blacklick, OHBuilt 2000 · S/N S1809 N396CPAir 1 LLC · Newark, DEBuilt 1994 · S/N S1683 N411JCFlying Z Ranch LLC · Douglas, WYBuilt 1986 · S/N S1201 N413LHRatcliff Dustin Matthew · Saltville, VABuilt 2008 · S/N S1925 N41THLammers Ross L · Cumming, GABuilt 1997 · S/N S1747 N503QDSchroth Charles D · Gustavus, AKBuilt 1977 · S/N 1170643 N511RJCarman Scott C · Port Orange, FLBuilt 2010 · S/N S1946 N515PHGulf Coast Helicopters Inc · Pearland, TXBuilt 1998 · S/N S1771 N521RSJj Airlift Inc · Broomfield, COBuilt 2006 · S/N S1891 N522TTHarris Kenneth L · Greeley, COBuilt 1990 · S/N S1471 N528WTRegistration Pending · New Smyrna Beach, FLRegistration pendingBuilt 2001 · S/N S1822 N53KFHaynes Robert Kent · Pilot Point, TXBuilt 1996 · S/N S1738 N557DCJoslyn Larry J · Las Vegas, NVBuilt 1993 · S/N S1630 N55PHElectrical Design Consultants Group LLC · Pepper Pike, OHBuilt 2002 · S/N 0145 N6120ABrabeck Mark F · Glasgow, MTBuilt 1991 · S/N S1520 N6126TGuida Associates Consulting Inc · Sandpoint, IDS/N S1496 N6128UJoslyn Larry J · Las Vegas, NVBuilt 1993 · S/N S1655 N6136KAll On Black LLC · Mount Nebo, WVBuilt 1994 · S/N S1672 N6147EBuckley Michael J · Billings, MTBuilt 1995 · S/N S1707 N61MJSnell Matthew Lea · Ackerly, TXBuilt 1990 · S/N S1483 N626LHHeli-Tech Inc · Panama City, FLBuilt 2008 · S/N S1917 N645KAHelocraft Holding Co Inc · Pembroke Pines, FLBuilt 2009 · S/N S1931 N656RBBas Part Sales LLC · Greeley, COBuilt 1997 · S/N S1744 N67TKBuckley Michael J · Billings, MTS/N S1838 N699LCAero Management LLC · Austin, TXBuilt 1999 · S/N S1775 N705RMReynolds Darryl G · Wills Point, TXS/N S1504 N71SLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N S1468 N721SPSchweizer Rsg LLC · Fort Worth, TXBuilt 1986 · S/N S1232 N7364HReam Aviation LLC · York, PABuilt 2010 · S/N S1938 N7492FHouston Police Dept · Houston, TXBuilt 2008 · S/N S1920 N7493FHouston Police Dept · Houston, TXBuilt 2008 · S/N S1921 N7504ZMid Pacific Aero Services LLC · Honolulu, HIS/N S1266 N75068Kinzie Industries Inc · Erie, COExpired dealerBuilt 1988 · S/N S1323 N7506NMeshoppen Air LLC · Tunkhannock, PABuilt 1988 · S/N S1305 N75070Mansfield Heliflight Inc · Milton, VTS/N S1404 N7507CBlair & Son Inc · Fleetwood, PABuilt 1988 · S/N S1349 N7507MWeststar Ventures LLC · Cannon Falls, MNBuilt 1989 · S/N S1365 N7507USierra Sky Aviation LLC · Kalispell, MTBuilt 1989 · S/N S1393 N7508HSons Aviation LLC · Moody, ALBuilt 1992 · S/N S1628 N7508LBruegger Shannon B · Lance Creek, WYBuilt 1989 · S/N S1417 N75105Mitchell Maverick LLC · Mitchell, SDBuilt 1994 · S/N S1677 N7511ACouch Construction Co LLC · Palestine, TXBuilt 1994 · S/N S1685 N767LHJones Aircraft Co LLC · Cross Plains, TNBuilt 2007 · S/N S1905 N776LHJones Aircraft Company LLC · Cross Plains, TNBuilt 2002 · S/N S1841 N789LHJones Aircraft Company LLC · Cross Plains, TNBuilt 2008 · S/N S1911 N811TTJordison Investments LLC · Auburn, WAS/N S1835 N817BWWalker Baylor L · Big Spring, TXBuilt 2001 · S/N S1813

Back to Schweizer 269C