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.

N771KKnutson Aviation Inc · Cedar Hill, TXBuilt 1977 · S/N 18052899 N7775KMarsh John E · Washington, DCS/N 18053071 N77JPDakota Aircraft Inc · Pierre, SDBuilt 1979 · S/N 18053123 N7838KDolphin Patrick D · Kenai, AKBuilt 1976 · S/N 18052772 N7841KJohnson Daniel K · Lampasas, TXBuilt 1976 · S/N 18052775 N7878WRegistered aircraftBuilt 1978 · S/N 18052936 N79SLCade David M · Asheville, NCBuilt 1979 · S/N 18053065 N80HXAthans Holdings LLC - Series 180 · Lake In The Hills, ILS/N 18053035 N80WTOtter Creek Lodge LLC · Big Timber, MTBuilt 1976 · S/N 18052784 N817Naumann Scott Trustee · Arroyo Grande, CAS/N 18052844 N8180Wayman Daniel M · Medford, ORBuilt 1981 · S/N 18053189 N820AKMabry Monte D · Anchorage, AKBuilt 1977 · S/N 18052892 N8276YVrem Kevin · Anchorage, AKBuilt 1977 · S/N 18052778 N82JWGaines Joseph M · Niceville, FLBuilt 1980 · S/N 18053162 N83CBDenton William P · Dallas, TXBuilt 1978 · S/N 18052992 N84USMcginty Flying Service LLC · Jones, LAS/N 18052942 N888FSBoock Thomas A · Fremont, CABuilt 1980 · S/N 18053163 N889TVD & P Gammill Farms · Marked Tree, ARBuilt 1979 · S/N 18053109 N9053ZTjossem Martin O · Paullina, IAS/N 18053143 N907RKKulin Robb M · Anchorage, AKBuilt 1978 · S/N 18052977 N92ATBroquet Bruce L · Anchorage, AKBuilt 1981 · S/N 18053169 N98207Perkins Robert T · Anchorage, AKBuilt 1977 · S/N 18052832 N99ABrown Ashley A · Fort Worth, TXS/N 18052789 N9HMRonay Thomas G Trustee · Nampa, IDBuilt 1980 · S/N 18053165

Back to Cessna 180K