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.

N438APWhiskey 340 LLC · Tucson, AZBuilt 1977 · S/N 340A0438 N43DAAero Management Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 340A0112 N4403ABank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 340A1014 N444JMPeck Joseph A · Pound Ridge, NYBuilt 1976 · S/N 340A0280 N444KTHangar G-1 Aviation Partners LLC · Los Olivos, CABuilt 1981 · S/N 340A1235 N444KWRaw Racing Inc · Puyallup, WAS/N 340A0241 N4557NWestra Aviation LLC · Beaver Dam, WIBuilt 1978 · S/N 340A0547 N4568NBergren Scott W Trustee · Walnut Creek, CABuilt 1978 · S/N 340A0549 N456WPMatagorda Production Co · Westhoff, TXBuilt 1979 · S/N 340A0766 N4578NAviation International LLC · El Paso, TXBuilt 1978 · S/N 340A0553 N4579NSeven Eight Juliet LLC · Edmond, OKBuilt 1978 · S/N 340A0479 N457DMMajor Development LLC · Cedaredge, COBuilt 1978 · S/N 340A0554 N4589NGeneric Implant Solutions LLC · Pratt, KSBuilt 1978 · S/N 340A0556 N4599FCcs Flight Services LLC · Benton Harbor, MIS/N 340A0652 N45TFWave Transportation LLC · Middletown, DEBuilt 1982 · S/N 340A1507 N4604NS O W Aviation LLC · Crystal River, FLBuilt 1980 · S/N 340A1016 N4674NBorderline Sky LLC · El Paso, TXBuilt 1980 · S/N 340A1023 N467DBParamont Services Inc · Newbury Park, CABuilt 1978 · S/N 340A0467 N4754AIndigo Air LLC · Gulf Breeze, FLBuilt 1980 · S/N 340A1024 N47645Arizona Type Ratings LLC · Sedona, AZBuilt 1980 · S/N 340A0992 N4833AEnoch Mark C · Rowlett, TXBuilt 1980 · S/N 340A1026 N486MHMh Group LLC · Duncan, OKBuilt 1978 · S/N 340A0481 N487KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 340A0240 N500CTLac Aero LLC · Liberal, KSBuilt 1981 · S/N 340A1236 N500EBKaizen Aircraft Holdings LLC · Kalispell, MTBuilt 1977 · S/N 340A0287 N500QVJands LLC · Broken Arrow, OKBuilt 1979 · S/N 340A0699 N501DCExecutive Aviation LLC · Peoria, AZBuilt 1981 · S/N 340A1267 N505SFLux William E · Newman Lake, WABuilt 1977 · S/N 340A0261 N510TFLang Eric O · Oklahoma City, OKBuilt 1978 · S/N 340A0499 N513DWright Aero Inc · Saint Cloud, MNBuilt 1976 · S/N 340A0048 N515BTAir Safety Investigators LLC · Nokomis, FLS/N 340A1816 N515DCmmk LLC · Talent, ORBuilt 1980 · S/N 340A-1022 N5169JPotter Kent W · Laurel, MTBuilt 1976 · S/N 340A0004 N5175JAycock Charles C · Midland, TXS/N 340A0010 N5178JSeven Eight Juliet LLC · Edmond, OKS/N 340A0013 N5181JForce One Inc · Missoula, MTBuilt 1975 · S/N 340A0016 N5182JEmery & Associates Inc · Orangeville, PAFirst renewal noticeS/N 340A0017 N518PCJnc Holdings LLC · Mequon, WIBuilt 1977 · S/N 340A0433 N519SCCrockett Ryan · Veradale, WAFirst renewal noticeBuilt 1979 · S/N 340A0720 N51APConrad Alan B · Las Vegas, NVBuilt 1980 · S/N 340A0970 N51CXAerodata LLC · Ann Arbor, MIBuilt 1978 · S/N 340A0533 N5227JSbs Partnership · Henderson, NVBuilt 1980 · S/N 340A1036 N5256JKamenz Donald R · Mocksville, NCBuilt 1977 · S/N 340A0403 N527JHTugende LLC · Montrose, COBuilt 1979 · S/N 340A0782 N52STWeicks Aviation LLC9634 · Cedar Falls, IAS/N 340A0696 N5316JCocola Gary M · Fresno, CABuilt 1977 · S/N 340A0405 N531MHigh Cotton Aero LLC · Murray, KYBuilt 1978 · S/N 340A0534 N5320JCorporate Air Charter Inc · Wilmington, DEBuilt 1977 · S/N 340A0407 N5324JSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A0410 N5328JKahler Automation Corp · Fairmont, MNBuilt 1977 · S/N 340A0412

Back to Cessna 340A