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.

N11896Mcginty Flying Service LLC · Jones, LABuilt 1977 · S/N 18052921 N11DHRegistered aircraftBuilt 1978 · S/N 18052974 N13297Borchers Lee A Trustee · Independence, ORBuilt 1980 · S/N 18053167 N13500Caldwell Bob · Columbus, MSBuilt 1980 · S/N 18053168 N144DRandall John R · Pearl River, LABuilt 1978 · S/N 18053001 N156MRegistered aircraftBuilt 1979 · S/N 18053114 N15PAFlight Dynamics LLC · De Leon Springs, FLBuilt 1980 · S/N 18053148 N15ZFRegistration Pending · Swan Valley, IDRegistration pendingBuilt 1977 · S/N 18052802 N175MMHarden Jon R · Ijamsville, MDBuilt 1978 · S/N 18053032 N180Moore James M · Grass Valley, CABuilt 1978 · S/N 18052946 N180AHSwiss Arctic Flyers Inc · Lewes, DEBuilt 1981 · S/N 18053192 N180BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18053103 N180DUSchlegel Mark O · Kingman, KSBuilt 1979 · S/N 18053012 N180DZAndrews Ruben · San Diego, CABuilt 1979 · S/N 18053094 N180ELInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 18053121 N180FJDrews Kelly R · Lakeville, MNBuilt 1977 · S/N 18052900 N180FPJunker Dean D · Avoca, IABuilt 1977 · S/N 18052917 N180HCHerbst Edward J · Las Vegas, NVBuilt 1978 · S/N 18052953 N180HKChina Pilot Inc Trustee · Wilmington, DEBuilt 1981 · S/N 18053191 N180KCThompson Robert M · Chandler, AZBuilt 1980 · S/N 18053141 N180KMLone Eagle Aviation LLC · Wilmington, DEBuilt 1979 · S/N 18053052 N180LLPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1977 · S/N 18052868 N180LMRegistration Pending · Anchor Point, AKRegistration pendingBuilt 1977 · S/N 18052811 N180LTTugaw Leslie T · Omak, WABuilt 1979 · S/N 18053120 N180LWNorthstar Adventures LLC · Port Alsworth, AKS/N 18052925 N180NTHuston Aaron C · Fox Island, WABuilt 1977 · S/N 18052813 N180PGRance Cory D · Moody, TXBuilt 1980 · S/N 18053135 N180WStein Anthony J · Locust Grove, GABuilt 1978 · S/N 18052988 N180WJPlane Fun Inc Tr Trustee · Snellville, GAS/N 18052873 N181RCWheeler Douglas N Trustee · Santa Fe, NMBuilt 1978 · S/N 18052982 N181RPCain Jeffrey B · Godley, TXBuilt 1981 · S/N 18053180 N183SKHill Vicki · Saint Joseph, LABuilt 1977 · S/N 18052824 N1845ZQuale Scott M · New Town, NDBuilt 1978 · S/N 180-52973 N1846ZFullerton Thomas M · Centennial, COBuilt 1978 · S/N 180-52968 N184JPSarita Aerial Contractors Inc · Casa Grande, AZBuilt 1979 · S/N 18052889 N18WLMiller Christopher M · Centreville, VABuilt 1981 · S/N 18053178 N19022Delta Lima Foxtrot LLC · Kalispell, MTBuilt 1980 · S/N 18053176 N19694Farrell Timothy S · New Meadows, IDBuilt 1981 · S/N 18053179 N19914Beck Robert A · Cove, ORBuilt 1981 · S/N 18053181 N1FHBuermann Henry · Brookfield, VTS/N 18052817 N20252Morino William D · Palos Verdes Est, CABuilt 1981 · S/N 18053183 N20315Drago Air LLC · Mulberry, INBuilt 1981 · S/N 18053184 N20379Diversified Aviation Services LLC · Madisonville, LABuilt 1981 · S/N 18053185 N20463Merritt Daniel D · Graham, WABuilt 1981 · S/N 18053187 N20514Bales Gregory W · Enterprise, ORBuilt 1981 · S/N 18053190 N20550Traskos Larry L Trustee · Port Orange, FLBuilt 1981 · S/N 18053194 N20605Registration Pending · Escondido, CARegistration pendingBuilt 1981 · S/N 18053199 N20640Cahoon Neil T · Camas, WABuilt 1981 · S/N 18053202 N2509KHolcomb John R · Siloam Springs, ARBuilt 1978 · S/N 18052962 N2513KCarlson Thomas G · Anchorage, AKBuilt 1978 · S/N 18052964

Back to Cessna 180K