Skip to content

Registered aircraft · 1,121

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 ('2072821', '2070107')
  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 ('2072821', '2070107')
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.

N5082EWeaver M Thomas · Kalispell, MTBuilt 1979 · S/N 18503928 N5088ES J Screw Company Inc T/A · Belvidere, NJBuilt 1979 · S/N 18503931 N508SDPate Charles C Trustee · Wichita, KSBuilt 1979 · S/N 18503980 N5090RStahla Russell A · Girdwood, AKBuilt 1976 · S/N 18503005 N509PGLake Stories LLC · Crosslake, MNBuilt 1977 · S/N 18503191 N50AWLillian Aviation LLC · Cypress, TXBuilt 1977 · S/N 18503528 N50TFLittlefield Keith A · Kent, WABuilt 1979 · S/N 18503952 N5108TMarks Daniel A · Portersville, PABuilt 1977 · S/N 18503274 N511JBPlp Aircraft Classics LLC · Wilmington, DEBuilt 1978 · S/N 18503509 N5145RSautner Steve · Anchorage, AKBuilt 1976 · S/N 18503008 N5159RBackcountry Adventures LLC · Big Lake, AKBuilt 1976 · S/N 18503011 N5172RWaterhouse Roy Todd · Mccall, IDBuilt 1976 · S/N 18503012 N5182HVanderpool Robert W · Red Devil, AKS/N 18503326 N519MQMgnh Services LLC · Houlton, MEBuilt 1983 · S/N 18504413 N520VASale Reported · Pleasant Grove, CASale reported, pending cancellationBuilt 1977 · S/N 18503352 N520YHTurnbull Timothy H · Mccall, IDBuilt 1978 · S/N 18503619 N5217ERamsey Thomas R · West Bath, MES/N 18503941 N5222RLebeouf Bros Towing LLC · Bourg, LABuilt 1976 · S/N 18503021 N5227RThomas Myles S · Fairbanks, AKBuilt 1976 · S/N 18503023 N522SSSouthern Seaplane Inc · Belle Chasse, LABuilt 1982 · S/N 18504388 N525JBWalton Jack R · Granbury, TXBuilt 1979 · S/N 18503907 N5278ESeasholtz John O · Fresno, CABuilt 1979 · S/N 18503949 N5285RPuddle Jumper Aviation LLC · Brighton, COS/N 18503027 N53006Hemphill Holdings LLC · Hemphill, TXBuilt 1973 · S/N 18502312 N53013Metzler Alan J · Reedsville, PABuilt 1973 · S/N 18502317 N53032Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1974 · S/N 18502326 N53044Trophy Down LLC · Punta Gorda, FLBuilt 1973 · S/N 18502334 N53046Tucker Thomas G · Dillingham, AKBuilt 1973 · S/N 18502336 N53055Echo Lake Air LLC · Soldotna, AKBuilt 1974 · S/N 18502343 N53057Endsley Gregory C · Sterling, AKBuilt 1974 · S/N 18502345 N53059Smith Sidney R Trustee · Rllng Hls Est, CABuilt 1974 · S/N 18502347 N53083Clearwater Potlatch Timber Protect · Orofino, IDBuilt 1974 · S/N 18502367 N53092Reilly Patrick M · Anchorage, AKBuilt 1974 · S/N 18502371 N5317RHayton James B · Sedro Woolley, WAS/N 18503031 N535WCMetro West Ambulance · Hillsboro, ORBuilt 1981 · S/N 18504195 N5370ESwanson Philip A · Star, IDBuilt 1980 · S/N 18503958 N5381EMiller Christopher D · Boulder, COBuilt 1979 · S/N 18503959 N5387HStene Aviation Inc · Polson, MTFirst renewal noticeBuilt 1977 · S/N 18503330 N5390E402wd Holdings LLC · Robstown, TXBuilt 1979 · S/N 18503961 N54007Romey Samuel A · Ketchikan, AKBuilt 1980 · S/N 18504026 N5403EBuness Timothy A · Wrangell, AKBuilt 1979 · S/N 18503963 N5412ESierra Skywagons LLC · Helena, MTBuilt 1979 · S/N 18503966 N5416RProsser William C · Wasilla, AKBuilt 1976 · S/N 18503036 N5418EOertli Holdings LLC · Pinehurst, IDBuilt 1979 · S/N 18503968 N543DGGavora Daniel E · Fairbanks, AKBuilt 1976 · S/N 18503157 N5468ELehr Robert J · Pleasant Dale, NEBuilt 1979 · S/N 18503979 N5485EColorado Parks And Wildlife · Grand Junction, COBuilt 1979 · S/N 18503981 N5486RGruenberg Steven G · Falmouth, MIS/N 18503039 N5494EBloom William K · Wrangell, AKBuilt 1979 · S/N 18503983 N54EJHigh Plains Aviation LLC · Caro, MIS/N 18504330

Back to Cessna A185F