Skip to content

Registered aircraft · 706

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

N4932SThunder Aviation LLC · Oro Valley, AZBuilt 1980 · S/N R18201471 N4933SHedden Larry H · Huntsville, ALBuilt 1980 · S/N R18201334 N4934SFerrell Charles A · Stockton, CABuilt 1980 · S/N R18201473 N4936TDakma LLC · Parma, OHBuilt 1981 · S/N R18201794 N4937SRauch James A III · Cayce, SCBuilt 1980 · S/N R18201476 N4937TSalsbery Enterprises Inc · Sharpsville, INBuilt 1981 · S/N R18201795 N4944SEmbry Riddle Aeronautical University · Prescott, AZBuilt 1980 · S/N R18201483 N4947SZams Aviation LLC · Raleigh, NCBuilt 1980 · S/N R18201486 N5012REmd Aviation LLC · Carlsbad, CABuilt 1978 · S/N R18200626 N50CPAtkins Daniel E · Marlette, MIBuilt 1978 · S/N R18200246 N50CXChristmas Candy · Angel Fire, NMBuilt 1979 · S/N R18201040 N5131T3b'S Land Development LLC · Seattle, WAS/N R18201821 N515BBQuad B Flying LLC · Mitchellville, IABuilt 1978 · S/N R18200486 N5160TBeaver Enterprises Inc · Wilmington, DEBuilt 1981 · S/N R18201827 N5171SHalsted Holdings LLC · Yankton, SDBuilt 1980 · S/N R18201513 N517MSJewett John G · Ellensburg, WABuilt 1978 · S/N R18200681 N5212TCnw Holdings LLC · Wilmington, DEBuilt 1981 · S/N R18201835 N5231TRegistration Pending · Cottonwood, AZRegistration pendingBuilt 1981 · S/N R18201839 N5239SHunnicutt Donald C · Meridianville, ALBuilt 1980 · S/N R18201521 N5267SAviation Psych LLC · Neptune Beach, FLBuilt 1980 · S/N R18201530 N5269SCanyon Blue LLC · Sharpsburg, GABuilt 1980 · S/N R18201531 N5273TFunk Michael W · Windham, NHBuilt 1982 · S/N R18201846 N5274SHap'S Air Inc · Ames, IABuilt 1980 · S/N R18201534 N5284TSinclair James Stanley · Douglas, GAS/N R18201848 N5286TWilson Aviation LLC · Robinson, ILBuilt 1984 · S/N R18201849 N52AJMccarty Aaron T · Wasilla, AKBuilt 1977 · S/N R18200089 N52GVCompass Aviation Maintenance LLC · Shelby, NCBuilt 1978 · S/N R18200393 N530TACaprock Dairy LLC · Muleshoe, TXS/N R18201259 N5311SGagliardi Richard M Trustee · Mill Spring, NCBuilt 1980 · S/N R18201543 N5323SGrig Aero LLC · Tulsa, OKBuilt 1980 · S/N R18201546 N5350SSilver Tree LLC · Southern Pines, NCS/N R18201551 N5354SArcturus Bootes LLC · Wilmington, DEBuilt 1980 · S/N R18201552 N5358TCarr Jon C · Shell Knob, MOBuilt 1982 · S/N R18201860 N5385SMcginnis Air LLC · Rising Star, TXBuilt 1980 · S/N R18201563 N5391TV Y Aviation LLC · Gentry, ARS/N R18201862 N5412SBarrett E James · Queensbury, NYBuilt 1980 · S/N R18201567 N541JBHuffman Aviation LLC · Burleson, TXBuilt 1981 · S/N R18201752 N5425SBunn James W · New Port Richey, FLBuilt 1980 · S/N R18201570 N5462THebert David · Lafayette, LABuilt 1982 · S/N R18201874 N5465SSherwood Steven · Saint Louis, MOBuilt 1980 · S/N R18201579 N5473TTiernan Barton M · Anchorage, AKBuilt 1982 · S/N R18201876 N5482TDavis Thomas E · Wisconsin Rapids, WIBuilt 1982 · S/N R18201877 N5488SJanssen Paul · New Castle, INBuilt 1980 · S/N R18201586 N54WDHat Creek Aviation LLC · Hamilton, MTBuilt 1981 · S/N R18201709 N550JSBawk Aviation LLC · Xenia, OHBuilt 1977 · S/N R18200105 N5529SBreaking Wind Aviation LLC · Brainerd, MNBuilt 1980 · S/N R18201597 N5539TPattison Aero Inc · Henderson, NVS/N R18201889 N5544TPercario Joseph · Warren, NJBuilt 1982 · S/N R18201893 N5545SLareve Air LLC · Bloomfield, MIBuilt 1980 · S/N R18201604 N5545TMoody Bible Institute Of Chicago · Spokane, WABuilt 1982 · S/N R18201894

Back to Cessna R182