Skip to content

Registered aircraft · 56

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

N1112TRegistration Pending · Soldotna, AKRegistration pendingBuilt 1964 · S/N 50713 N17281Martin Air LLC · Fort Wayne, INBuilt 1960 · S/N 50774 N180BSSerie Dennis P · Chugiak, AKBuilt 1959 · S/N 624 N180RAWold John O III · Laurel, MTBuilt 1960 · S/N 50854 N280JPDraaisma Jacob Jr · Middleville, MIS/N 50825 N334SCGist Sally R · Horseshoe Bay, TXBuilt 1960 · S/N 50691 N451SWAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1960 · S/N 50885 N45WBDfw Aero Mechanix Inc · Oak Point, TXBuilt 1960 · S/N 50748 N49GLBobo Robert A · Pullman, WABuilt 1960 · S/N 50705 N514KKSchaperkotter Harold M Jr · Anchorage, AKBuilt 1960 · S/N 50796 N6406XIronsides Custom Grinding Inc · Waitsburg, WAS/N 50906 N694MDBice Eric L · Renton, WABuilt 1959 · S/N 50694 N706Old Aire LLC · Bellingham, WABuilt 1960 · S/N 50865 N757DJPanepinto Lane P · Lafitte, LAS/N 50717 N810JVCarstensen Ross J · Waterloo, NEBuilt 1960 · S/N 50784 N9171TLangmuir Circulation LLC · Perkasie, PABuilt 1959 · S/N 50671 N9177TBlaugher William S Jr · Fort Lauderdale, FLBuilt 1959 · S/N 50677 N9181TDieffenderfer John C · Palmer, AKBuilt 1959 · S/N 50681 N9183TLawrence Pratt G · Minerva, NYBuilt 1959 · S/N 50683 N9185TJones Justin · Wasilla, AKBuilt 1960 · S/N 50685 N9193TRich Edward L · Liberty, UTBuilt 1960 · S/N 50693 N9196TC9196tango LLC · Kalispell, MTBuilt 1960 · S/N 50696 N9197TRichardson Gordon P · Polson, MTBuilt 1960 · S/N 50697 N9199TFv Arianna Sage Inc · Chignik Lagoon, AKS/N 50699 N9203TMartinson Douglas E · Nome, AKS/N 50703 N9204TDoner Daniel D · Highlands Ranch, COBuilt 1960 · S/N 50704 N9206TZack Colson L · Hood River, ORBuilt 1960 · S/N 50706 N9207TRed Olive Bashir LLC · Spencerville, OHBuilt 1960 · S/N 50707 N9208TLund Philip Carl Trustee · Fort Mcdowell, AZBuilt 1960 · S/N 50708 N9209TTop Hand Inc · Laurel, MTBuilt 1960 · S/N 50709 N9211TSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 50711 N9229TLorenzen Kraig E · Pagosa Springs, COBuilt 1959 · S/N 50729 N9231TStreit Jeffrey L · Palmer, AKBuilt 1960 · S/N 50731 N9234TKrause Hugh A · Turtle River, MNBuilt 1960 · S/N 50734 N9236TSpirit Engineering Inc · Grand Junction, COBuilt 1960 · S/N 50736 N9245TCook Erik C · Redmond, ORBuilt 1960 · S/N 50745 N9253TMichael J Kraynick Pllc · Hailey, IDBuilt 1960 · S/N 50753 N9254TLuper Gary M · Anchorage, AKBuilt 1960 · S/N 50754 N9255TShepp Carl R Jr · Florence, MTBuilt 1960 · S/N 50755 N9265TFpg Agri Services LLC · Frost, TXBuilt 1960 · S/N 50765 N9267TDeeds Andy · Larkspur, COBuilt 1960 · S/N 50767 N9272TAkers Dana M · Kingston, NHBuilt 1960 · S/N 50772 N9282TCloud 9 Aviators LLC · Anchorage, AKBuilt 1960 · S/N 50782 N9295TViking Custom Builders Inc · Anchorage, AKBuilt 1960 · S/N 50795 N9297TSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 50797 N9311TCrouse John A · Sterling, AKBuilt 1960 · S/N 50811 N9332TMiller Aircraft Services Inc · Crookston, MNBuilt 1960 · S/N 50832 N9333TLiley Paul T · Anchorage, AKBuilt 1960 · S/N 50833 N9334TNelson Scott M · Eagle River, AKBuilt 1960 · S/N 50834 N9343TJansen Guy A · Lynden, WABuilt 1960 · S/N 50843

Back to Cessna 180C