Skip to content

Registered aircraft · 21

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

N103DTPrescott Stephen I · Cornish, MES/N 320B0004 N22PTGuy Transportation Ltd · Wilmington, DEBuilt 1963 · S/N 320B0039 N299AOverman Robert W · Fairfield, OHBuilt 1964 · S/N 320B-0057 N320DBBodian Aakil · Martinez, GAS/N 320B0015 N320HHartwell John E · Pleasanton, CABuilt 1964 · S/N 320B0060 N320PPIpock Brian P · Tulsa, OKS/N 320B0018 N320RDBurwell Michael · W Bloomfield, MIBuilt 1963 · S/N 320B0035 N320TJBlaylock Arthur S III · Pace, FLBuilt 1963 · S/N 320B0017 N4207NHoover Brian A · Warsaw, INBuilt 1964 · S/N 320B0047 N4500VBales Philip J · Chandler, AZBuilt 1964 · S/N 320B0053 N66552Janak Jeffrey · Corpus Christi, TXBuilt 1963 · S/N 320B0003 N810SLidman Kirby · Ames, IABuilt 1964 · S/N 320B0062 N882GLProctor Brian S · Leesburg, TXBuilt 1963 · S/N 320B0026 N9809LSouthern Utah University · Cedar City, UTS/N 320B0009 N9812LGreer Resources LLC · Hesperus, COS/N 320B-0012 N9816LTolbert Doug G · Idaho Falls, IDBuilt 1963 · S/N 320B0016 N9825LSanders Russell G · Bakersfield, CAS/N 320B0025 N9831LCrawford Brad C · Hot Springs, ARBuilt 1963 · S/N 320B0031 N9836LYoung Robert · Wichita, KSBuilt 1964 · S/N 320B0036 N9844LDt Equipment Leasing LLC · Ten Sleep, WYBuilt 1964 · S/N 320B0044 N9856LBrown Eric · Pioneer, CABuilt 1964 · S/N 320B0056

Back to Cessna 320B