Skip to content

Registered aircraft · 274

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

N2524KGanz Brian L · Carlsbad, CABuilt 1978 · S/N 18052969 N2530KInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 18052972 N2537KPanuski Christopher Louis · Davidson, NCBuilt 1978 · S/N 18052978 N2546KSkywagon 1 LLC · Boynton Beach, FLBuilt 1978 · S/N 18052981 N2552KRicci Harry A · Kokhanok, AKBuilt 1978 · S/N 18052983 N2554KBelleair Aviation LLC · Clearwater, FLS/N 18052985 N2556KCarlson Steven J · Fairbanks, AKS/N 18052986 N2567KBryant Kenneth D · Black Diamond, WABuilt 1978 · S/N 18052990 N2569KHarris Curtis M · Anchorage, AKS/N 18052991 N2573KDonham Sonjia F · Portland, ORBuilt 1978 · S/N 18052995 N2575KSchlick David L · Poulsbo, WABuilt 1978 · S/N 18052997 N2579KSkywagon LLC · Sterling, AKBuilt 1978 · S/N 18053000 N2581KYsc Inc · Harvard, MABuilt 1978 · S/N 18053002 N2582KSherman David B · Readfield, MEBuilt 1978 · S/N 18053003 N2584KEichorn Russell A · Grand Rapids, MNBuilt 1978 · S/N 18053005 N2590KHilltop Aviation Group LLC · Jay, MEBuilt 1978 · S/N 18053006 N2597KCrossno James · Fulshear, TXBuilt 1978 · S/N 18053010 N2603KPadilla Management Inc · Burlington, WABuilt 1978 · S/N 18053013 N2626KUpwind Floats LLC · Seattle, WABuilt 1979 · S/N 18053019 N2635KVerdi Stephen · Newtown, PABuilt 1978 · S/N 18053020 N2643KWashington Walt W · Collierville, TNBuilt 1978 · S/N 18053023 N2645KFowlkes John M Trustee · Marfa, TXBuilt 1978 · S/N 18053024 N2647KBoice Petroleum Consulting LLC · Pinedale, WYS/N 18053025 N2656KT And H Aircraft Leasing LLC · Yakutat, AKBuilt 1978 · S/N 18053029 N2676KFurey Michael J · Hazlehurst, MSS/N 18053033 N2677KAeropod Inc · Aurora, COS/N 18053034 N2697KPrince John C III · Frierson, LABuilt 1979 · S/N 18053038 N26MDMccue Gregory P · Cody, WYBuilt 1980 · S/N 18053144 N2705KRegistered aircraftBuilt 1979 · S/N 18053040 N272SCRobert Gardner Enterprises LLC · Mercer, MEBuilt 1977 · S/N 18052939 N2731KYoung Aviation LLC · Oshkosh, WIBuilt 1979 · S/N 18053045 N2732KDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1979 · S/N 18053046 N2735KCook Kyle R · Green Valley, AZBuilt 1979 · S/N 18053049 N2736KP M Logistics LLC · Haskell, OKBuilt 1979 · S/N 18053050 N2737KFanazick Joseph P · Juneau, AKBuilt 1979 · S/N 18053051 N2744KLucas Greg C · Elmore City, OKS/N 18053057 N2749KAero Applicators Inc · Sterling, COBuilt 1979 · S/N 18053059 N2769KMillennium Air Inc · Maurice, IAS/N 18053064 N2785KPontiac Flying LLC · Pontiac, ILBuilt 1979 · S/N 18053067 N2787KWhirlwind Aviation Inc · Fisher, ARBuilt 1979 · S/N 18053068 N2801KGerrity James L · Homer, AKBuilt 1979 · S/N 18053072 N2802KBloom Timothy Scott · Chugiak, AKBuilt 1979 · S/N 18053073 N2803KMunro Gregg · Kenmore, WABuilt 1979 · S/N 18053074 N2805KNorthstar E & C LLC · Anchorage, AKBuilt 1979 · S/N 18053076 N2807KLeseberg Mark E · Minden, NVBuilt 1979 · S/N 18053078 N2808KCam Corporation · Fairbanks, AKBuilt 1979 · S/N 18053079 N2810KWair Inc · Mount Vernon, WABuilt 1979 · S/N 18053081 N2811KHayward Houston C · Lansdale, PABuilt 1979 · S/N 18053082 N2812KSylvester John A · Hereford, AZBuilt 1979 · S/N 18053083 N2814KMacario Mark A · Weirsdale, FLBuilt 1979 · S/N 18053085

Back to Cessna 180K