Skip to content

Registered aircraft · 543

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 ('2076405', '2073325')
  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 ('2076405', '2073325')
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.

N8856KHerrmann Alan J · Laguna Niguel, CABuilt 1981 · S/N 340A1264 N8857KBall Bearing Aviation LLC · Lowell, ARBuilt 1979 · S/N 340A0642 N886BATerzo Richard E · Lake Zurich, ILBuilt 1981 · S/N 340A1269 N888BPXyz1234 LLC · Addison, TXBuilt 1979 · S/N 340A0737 N888MTSpelts Mark Warren Trustee · Chico, CABuilt 1979 · S/N 340A0763 N8941GHawks Eye View LLC · Roanoke, VAS/N 340A0327 N895ACTejas Cavu LLC · Wilmington, DEBuilt 1978 · S/N 340A0558 N898LMMlm Aviation LLC · Mars Hill, NCBuilt 1977 · S/N 340A0254 N8991GAll Trimmed Out LLC · Pierre, SDBuilt 1977 · S/N 340A0329 N900TCBlanco James A · El Dorado Hills, CABuilt 1976 · S/N 340A0210 N908CKNew Tex Capital LLC · Plains, TXBuilt 1978 · S/N 340A0445 N909DCTwin Piston Aviation LLC · Salisbury, NCBuilt 1980 · S/N 340A0998 N91053Garvin Lee E · Brookings, ORS/N 340A1039 N912WTNew Tech Construction LLC · Wilmington, DEBuilt 1977 · S/N 340A0353 N915Ramsey Brent C · Tulsa, OKBuilt 1980 · S/N 340A0910 N921KARay Aviation LLC · Carmel, INBuilt 1984 · S/N 340A1803 N928CRCasas De Colores Inc · Santa Fe, NMBuilt 1977 · S/N 340A0434 N929DCPremier Flight LLC · El Cajon, CABuilt 1979 · S/N 340A0934 N92DLDavis Air LLC · Phoenix, AZBuilt 1976 · S/N 340A0204 N92WH322ee Aviation LLC · Union, KYBuilt 1977 · S/N 340A0271 N936JBHunt Air LLC · Anderson, SCBuilt 1977 · S/N 340A0263 N953DMMainline Services Co · Wilmington, DEBuilt 1976 · S/N 340A0205 N956EALopez Fabio · Denver, NCBuilt 1976 · S/N 340A-0085 N958MDGko Aviation LLC · Wilmington, DES/N 340A0734 N959DCKpp Air LLC · Navasota, TXBuilt 1980 · S/N 340A0942 N97DFFlying G Aviation LLC · Elizabeth, COBuilt 1978 · S/N 340A0510 N981DMMartin David E · Dallas, TXBuilt 1975 · S/N 340A0028 N983JBConstellation Aviation LLC · Rock Springs, WYBuilt 1978 · S/N 340A0453 N98533Bla Holdings LLC · Mcminnville, TNBuilt 1976 · S/N 340A0022 N98554Hawke Air Corp · Helena, MTBuilt 1976 · S/N 340A0030 N98579Bailey Switch Rentals LLC · Bluefield, VABuilt 1976 · S/N 340A0041 N98590Tuc-Mex LLC · Nogales, AZBuilt 1976 · S/N 340A0049 N98613Aero Innovations LLC · Tempe, AZBuilt 1976 · S/N 340A0057 N98616Le Loi · Baton Rouge, LABuilt 1976 · S/N 340A0059 N98624Jensen Hans · Gig Harbor, WABuilt 1976 · S/N 340A-0064 N986MSRush Aviation LLC · Hayden, IDS/N 340A0902 N98747American Skyways Inc · Corning, NYBuilt 1976 · S/N 340A0065 N988DMHart Paul E · El Macero, CABuilt 1981 · S/N 340A1244 N98MMSrt Group Inc · Southaven, MSBuilt 1979 · S/N 340A0639 N990JBMurphy George E · Robinson, ILBuilt 1977 · S/N 340A0370 N999DCTbm Avenger Inc · Peru, ILBuilt 1976 · S/N 340A0035 N999EBEngines Inc · Jonesboro, ARBuilt 1979 · S/N 340A0951 N9RYDpr Capital LLC · Farmington, UTS/N 340A0211

Back to Cessna 340A