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.

N4707BOlathe Spray Service Inc · Olathe, COBuilt 1955 · S/N 31605 N4708VSpears Patricia C · Longmont, COBuilt 1953 · S/N 30165 N4714BGeissler Charles H · Stanton, MNBuilt 1955 · S/N 31612 N4716BClose Keith · Anchorage, AKBuilt 1955 · S/N 31614 N4718BMartin Nathaniel W Trustee · Wasilla, AKBuilt 1955 · S/N 31616 N4722BHill James P · Eagle Point, ORBuilt 1955 · S/N 31620 N4724BSchlink Richard L · Soulsbyville, CABuilt 1955 · S/N 31622 N4728BN4728b Cessna 180 LLC · Colorado Springs, COBuilt 1955 · S/N 31626 N4735VCheney David R · Sun Lakes, AZBuilt 1953 · S/N 30599 N4738BEarhart Robert E · Dallas, TXBuilt 1955 · S/N 31636 N4740BCallahan Brian L Trustee · Kuna, IDBuilt 1955 · S/N 31638 N4743BAmstrup Norm D · North Pole, AKBuilt 1955 · S/N 31641 N4748USmith-Heffernan Heather · Frisco, TXBuilt 1965 · S/N 18051448 N4749BNunley Tim L · Palmer, AKBuilt 1955 · S/N 31647 N4750BConley Michael A · Mount Blanchard, OHS/N 31648 N4751BRegistered aircraftBuilt 1955 · S/N 31649 N4752CShannon Alton P · Intl Falls, MNBuilt 1955 · S/N 31650 N4758BJaars Inc · Waxhaw, NCS/N 31656 N4759BHoover Michael B · Ridgeland, WIS/N 31657 N4762BAllen Kenneth W · Anchorage, AKBuilt 1955 · S/N 31660 N4768BEversole Eric L · Kent, WABuilt 1955 · S/N 31666 N4769BNesbett David A Trustee · Anchorage, AKBuilt 1955 · S/N 31667 N4773BRegistered aircraftBuilt 1955 · S/N 31671 N4774BCunningham Martin Alden · Kansas City, MOBuilt 1955 · S/N 31672 N4775BChavez Edward C · Boise, IDBuilt 1955 · S/N 31673 N4776BLarsen Christopher F · Fairbanks, AKBuilt 1955 · S/N 31674 N4783BRogge Gary L · Fowler, COBuilt 1955 · S/N 31681 N4784BPhyfe Andrew L · Cape Coral, FLBuilt 1955 · S/N 31682 N4790BKringle Wendell K · Barron, WIBuilt 1955 · S/N 31688 N4796BHough Kenneth R · New Gloucester, MEBuilt 1955 · S/N 31694 N4798BRegistered aircraftBuilt 1955 · S/N 31696 N47CPHibler Philip Earl · Alameda, CABuilt 1957 · S/N 32304 N4802BJilek Ray A · Spearfish, SDBuilt 1954 · S/N 31600 N4807PMadigan Michael · Maryville, TNS/N 18053182 N4900ABaum James L Trustee · Anchorage, AKBuilt 1956 · S/N 32297 N4901ASchneberger C J · Clinton, IARevoked, canceledBuilt 1956 · S/N 32298 N4902ACavanagh Michael B · Dubois, WYBuilt 1956 · S/N 32299 N4903AKendall Ted O · Lakeside, CAS/N 32300 N4909ANastro Kristopher Jason · Fallon, NVS/N 32306 N4910AEverett Laurence B · Berkley, CABuilt 1956 · S/N 32307 N4911ASatra Jerry J · Sidney, MTBuilt 1956 · S/N 32308 N4913AOlson David J · Eugene, ORBuilt 1956 · S/N 32310 N4916APerkins Larry L DBA · Lake Elsinore, CABuilt 1956 · S/N 32313 N4918AMerrill Reese D · Brush Prairie, WAS/N 32315 N4920ABerry Thomas R · Anchorage, AKBuilt 1956 · S/N 32317 N4921AHogan William J · Libby, MTBuilt 1956 · S/N 32318 N4923ADaniel Arthur D · Fishtail, MTBuilt 1956 · S/N 32320 N4924AMachnik Todd J · Old Lyme, CTBuilt 1956 · S/N 32321 N4926AEngland John James · Montrose, COBuilt 1956 · S/N 32323 N4929AApling Randall L · Wasilla, AKFirst renewal noticeBuilt 1954 · S/N 32326

Back to Cessna 180