Skip to content

Registered aircraft · 1,177

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

N1592CPulver Douglas A · Kenockee, MIBuilt 1953 · S/N 30292 N1593CPeacock Richard M · Swansboro, NCS/N 30293 N1594CFlyrs Field · Anchorage, AKBuilt 1953 · S/N 30294 N1596CFennell Kenneth J · Palmer, AKBuilt 1953 · S/N 30296 N1601CRoss Dale · Washtucna, WABuilt 1953 · S/N 30301 N1603CJackson Zachariah J · Brainerd, MNBuilt 1953 · S/N 30303 N1605CMiller Robert H · South Beloit, ILBuilt 1953 · S/N 30305 N1607CAmos Walt · Sandy, UTBuilt 1953 · S/N 30307 N1608CMiller Gerald Roy · Denver, NCBuilt 1953 · S/N 30308 N1609CBerry John C · Thunderbolt, GABuilt 1953 · S/N 30309 N1612CBeck Robert A · Cove, ORBuilt 1953 · S/N 30312 N1614CMaggie L Air Service LLC · Kalispell, MTS/N 30314 N1616CCleared Direct LLC · Seville, OHBuilt 1953 · S/N 30316 N1617CRetroair Restoration LLC · Big Lake, AKBuilt 1953 · S/N 30317 N1622CPutnal Aviation LLC · Ambrose, GABuilt 1953 · S/N 30322 N1623CCarlson Thomas G · Anchorage, AKS/N 30323 N1626CLabrecque Maurice O · Anchorage, AKBuilt 1953 · S/N 30326 N1627CTerry Michael R Trustee · Bullhead City, AZBuilt 1953 · S/N 30327 N1630CRjd Flyers LLC · Mount Juliet, TNBuilt 1953 · S/N 30330 N1632CWarren Mark W · Arlington, WABuilt 1953 · S/N 30332 N1637CAshby Clark S · Pleasant Grove, UTBuilt 1953 · S/N 30337 N1644CAero 290 LLC · Burlington, WIBuilt 1953 · S/N 30344 N1645CRoach Aviation LLC · Longview, TXBuilt 1953 · S/N 30345 N1650CBrokaw Samuel J · South Bend, INBuilt 1953 · S/N 30350 N1653CLoveness Ghyrn E · Cave Creek, AZBuilt 1953 · S/N 30353 N1655CMardis Nicky Lee · Goddard, KSBuilt 1953 · S/N 30355 N1656CAnderson Thomas R · Seattle, WABuilt 1953 · S/N 30356 N1657CBrauchler Ben H · Hernando, MSBuilt 1953 · S/N 30357 N1669Berardinelli Michael A · Meridian, IDBuilt 1955 · S/N 31946 N1670CAlaska Freight Services LLC · Fairbanks, AKBuilt 1953 · S/N 30370 N1674CFarwest Aviation LLC · Billings, MTBuilt 1953 · S/N 30374 N1677CDavis Aero LLC · Incline Village, NVBuilt 1953 · S/N 30377 N1680CRogers Terrence W · Almond, WIBuilt 1953 · S/N 30380 N1681CClark Eddie · Naknek, AKBuilt 1953 · S/N 30381 N1682CFly & Fish LLC · Kalispell, MTBuilt 1953 · S/N 30382 N1684CBredin William B · Anchorage, AKS/N 30384 N1685CBallard Heather A · Pleasant Prairie, WIS/N 30385 N1686CButts Michael D · Carson City, NVBuilt 1953 · S/N 30386 N1691CSchrom Edward C · Manchester, PABuilt 1952 · S/N 30391 N1692CVandevoorde Gary A · Davenport, IABuilt 1953 · S/N 30392 N1693CDeardorff Dallas · Plains, MTS/N 30393 N1695CSpeed Richard · Boise, IDBuilt 1953 · S/N 30395 N1696CCarraher Mark T · Spalding, NEBuilt 1953 · S/N 30396 N1699CGrismer Jeff Trustee · Hemet, CABuilt 1953 · S/N 30399 N169FTHolmstrom Darrell D Trustee · Anchorage, AKBuilt 1956 · S/N 32389 N1700CKrause Kade G · Jackson, MTBuilt 1953 · S/N 30400 N1702CCork Dennis R · Soldotna, AKBuilt 1953 · S/N 30402 N1708CHaggard Roy A · Murrieta, CABuilt 1953 · S/N 30408 N1709CDmj Holdings LLC · Kalispell, MTBuilt 1953 · S/N 30409 N1710CSmith Peter R · Lewistown, MTBuilt 1953 · S/N 30410

Back to Cessna 180