Skip to content

Registered aircraft · 784

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

N9469ZEly John E · Prosser, WAS/N 33940 N9768XLeary Tyler P · Lewistown, MTS/N 34100 N989SDFlyby Equipment LLC · Factoryville, PABuilt 1957 · S/N 34207 N9900BS & L Aviation LLC · Buhl, IDS/N 34300 N9901BNichols Patrick C · Fairview, NCBuilt 1957 · S/N 34301 N9907BMalone Parachute Club Inc · Williston, VTBuilt 1957 · S/N 34307 N9911BGustafson Kim · Lake Stevens, WABuilt 1957 · S/N 34311 N9922BStix David Jr · Fernley, NVBuilt 1957 · S/N 34322 N9923BFurtak Stephen A · San Diego, CAS/N 34323 N9925BMartell Summer · Port Townsend, WABuilt 1957 · S/N 34325 N9928BHayton James B · Sedro Woolley, WAS/N 34328 N9933BHenkemeyer Joseph S · Cave Creek, AZBuilt 1957 · S/N 34333 N9934BMasterson Kevin M · Eagle River, AKBuilt 1957 · S/N 34334 N9935BCarpenter Willard D · Borrego Springs, CABuilt 1957 · S/N 34335 N9941BBrinkley Christian D · Minneapolis, MNBuilt 1957 · S/N 34341 N9946BFuehrer John G II · Ephrata, PABuilt 1957 · S/N 34346 N9947BClarke Adam M · Lompoc, CAS/N 34347 N9954BWest James R · Xenia, OHS/N 34354 N9957BToby Aviation LLC · Manassas, VABuilt 1957 · S/N 34357 N9958BSouthern Aircraft Leasing LLC · Montgomery, ALS/N 34358 N9959BHackamore Equipment LLC · Prairie City, SDBuilt 1957 · S/N 34359 N9960BSouthern Aircraft Leasing LLC · Montgomery, ALBuilt 1957 · S/N 34360 N9965BTuma Tom · Cut Bank, MTS/N 34365 N9966BKimbrell Heath · Quinlan, TXS/N 34366 N9976BArend Robert E Jr DBA · Mark Center, OHBuilt 1957 · S/N 34376 N9977EDunlap Cameron · Campbell, NYBuilt 1958 · S/N 34853 N9978BReal Brian M · Anchorage, AKBuilt 1957 · S/N 34378 N9979B79bravo Leasing LLC · Lincoln, DEBuilt 1957 · S/N 34379 N9980BBudenbender Philip W · Weatherford, TXBuilt 1957 · S/N 34380 N9983BMartyn Michael L · Ridgecrest, CABuilt 1957 · S/N 34383 N9992BAirco International LLC · Arlington, WABuilt 1957 · S/N 34392 N9993BTurinsky Anthony · Anchorage, AKS/N 34393 N9995BAlbatross Air Inc · Mccall, IDS/N 34395 N9999BMccole Kevin · Brookline, NHBuilt 1957 · S/N 34399

Back to Cessna 182A