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.

N340GTWow-We Wings LLC · Pawleys Island, SCBuilt 1981 · S/N 340A1249 N340GWThree Rivers Limousine Service Inc · Pittsburgh, PABuilt 1979 · S/N 340A0706 N340HCPropjet 210 Aviation Inc · Windsor, CAS/N 340A0638 N340HESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 340A1503 N340HWHartung Stefan · Greenville, SCBuilt 1976 · S/N 340A0265 N340JCS O W Aviation LLC · Crystal River, FLBuilt 1979 · S/N 340A0801 N340JFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 340A0451 N340JLLechman Joseph · Agoura Hills, CABuilt 1982 · S/N 340A1543 N340JMHunter Pilot Services LLC · Hollister, CABuilt 1978 · S/N 340A0640 N340JQLiu Qi · Saratoga, CAS/N 340A0279 N340JSAsher Kenneth Edward · Durango, COBuilt 1979 · S/N 340A0661 N340KRegistered aircraftBuilt 1979 · S/N 340A0792 N340KCRegistered aircraftBuilt 1980 · S/N 340A0959 N340KGAero Vulcan LLC · Moody, ALBuilt 1982 · S/N 340A1505 N340KSDavieation III LLC · St Simons Is, GABuilt 1981 · S/N 340A1501 N340KTN44fu LLC · Oklahoma City, OKBuilt 1977 · S/N 340A0356 N340KYE Lite Aviation Inc · Cordova, TNFirst renewal noticeBuilt 1978 · S/N 340A0622 N340L310 Air Ltd · Seville, OHBuilt 1978 · S/N 340A0518 N340LEThree Forty LLC · Saint George, UTS/N 340A0233 N340LHAviation Limited Holdings LLC · Albuquerque, NMBuilt 1977 · S/N 340A0409 N340LLFrank Leasing LLC · Scottsbluff, NES/N 340A1228 N340LMCrawford William K · Indianapolis, INBuilt 1978 · S/N 340A0478 N340LQDownwind Flight LLC · San Antonio, TXBuilt 1976 · S/N 340A0020 N340MBRecon Real Estate Consultants Inc · El Paso, TXBuilt 1982 · S/N 340A1508 N340ME58gp Wing LLC · Wilmington, DEBuilt 1978 · S/N 340A0550 N340MFMerrill Farms · Corral De Tierra, CABuilt 1982 · S/N 340A1542 N340MGN340mg LLC · Highlands Ranch, COS/N 340A0769 N340MHFlying High Llp · Williston, NDBuilt 1981 · S/N 340A-1214 N340MJAll-Star Executive Aviation Inc · Pomona, CABuilt 1993 · S/N 340A1521 N340MKMilbern Aircraft Corporation · Brooklyn, NYBuilt 1982 · S/N 340A1541 N340MLD & L Airlines LLC · West Chester, OHBuilt 1979 · S/N 340A0729 N340MMRegistered aircraftS/N 340A0238 N340MPPaxell Aviation LLC · Springdale, ARS/N 340A0359 N340MSSprings1781 LLC · Colorado Springs, COBuilt 1979 · S/N 340A0760 N340MWInternational Air Services Inc Trustee · Carson City, NVS/N 340A0101 N340MYAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A-0906 N340NN-Number Inc · Santa Fe, NMBuilt 1982 · S/N 340A1540 N340PCDouble J Aviation LLC · Burlington, WIBuilt 1979 · S/N 340A0962 N340PFSharon Leasing Co · Ludington, MIBuilt 1977 · S/N 340A0225 N340PPRegistered aircraftBuilt 1979 · S/N 340A0747 N340PWValiair Limited Co Trustee · Casper, WYS/N 340A0933 N340RASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 340A0038 N340RBCorcoran Kim C Trustee · Burrton, KSBuilt 1978 · S/N 340A0498 N340RFN340rf LLC · Denver, COBuilt 1976 · S/N 340A0212 N340RJStohr Jeffry M · Aberdeen, SDS/N 340A0273 N340RPMeister Scott R · Skillman, NJBuilt 1979 · S/N 340A0733 N340RSWestermeyer Holdings LLC · Longville, MNBuilt 1977 · S/N 340A0371 N340SBStarlight Express LLC · Bellevue, WABuilt 1979 · S/N 340A0724 N340SDRegistration Pending · Kaukauna, WIRegistration pending, canceledS/N 340A0408 N340SGN340sg Leasing LLC · Sheridan, WYBuilt 1980 · S/N 340A0973

Back to Cessna 340A