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.

N180DGHodnett Stephen T · Canadian, TXBuilt 1955 · S/N 31280 N180DJHuang Sophie M · Newcastle, WABuilt 1954 · S/N 31154 N180DSCrawford E Clarke · Flagstaff, AZBuilt 1954 · S/N 30804 N180DTWalton Indy R · Soldotna, AKBuilt 1954 · S/N 31023 N180ECDarb Inc · Lakeville, MNS/N 32268 N180EHMccall Edmund B · Portland, ORBuilt 1955 · S/N 32116 N180ESRegistration Pending · Gillette, WYRegistration pendingBuilt 1954 · S/N 31047 N180ETHoffpauir Amanda E · Danevang, TXBuilt 1953 · S/N 30667 N180FFMach.180 Airlines LLC · Denver, COBuilt 1955 · S/N 32088 N180FLDga Aviation LLC · Sacramento, CABuilt 1956 · S/N 32591 N180FNRivet Inc Trustee · Wilmington, DEBuilt 1981 · S/N 18053201 N180FSShea Frank R · Colchester, VTBuilt 1954 · S/N 31068 N180FTJohnson John J · Wasilla, AKBuilt 1954 · S/N 31083 N180GBAlbrecht Romaine C · Ohio, ILBuilt 1953 · S/N 30498 N180GRSkie Aero · Campbell, CAS/N 50664 N180GTHayes Kurt L · Norman, OKBuilt 1955 · S/N 31456 N180HDRoper Philip D · Wasilla, AKBuilt 1953 · S/N 30104 N180HVVansoestbergen Harry J · Lincoln University, PABuilt 1955 · S/N 31551 N180JDMerritt Jerome E · Oroville, CAS/N 32144 N180JFAlexander Andrew B · Anchorage, AKBuilt 1953 · S/N 30631 N180JHKlein Flying Service · Lawrenceville, ILBuilt 1955 · S/N 31702 N180JKForbes James A · Monkton, MDBuilt 1980 · S/N 18053173 N180JPMcmanamin John P · Anchorage, AKBuilt 1955 · S/N 31630 N180JTSproul Andrew W · Isabella, OKFirst renewal noticeBuilt 1955 · S/N 31473 N180JVBf Aviation LLC · Boulder, COBuilt 1953 · S/N 30136 N180KPPerhus Kelly E · Kindred, NDBuilt 1955 · S/N 31285 N180LLietz Terry · Peshastin, WABuilt 1955 · S/N 31450 N180LEEverhart Leon J III · Gould City, MIBuilt 1955 · S/N 31645 N180LGBrisson Gisele A · Hollister, CABuilt 1955 · S/N 31380 N180LHHubbert Larry · Belding, MIS/N 18031708 N180MBBowers Michael J · Chugiak, AKBuilt 1954 · S/N 30663 N180MHRegistered aircraftBuilt 1953 · S/N 30546 N180MJHoke Michael J · Highlands Ranch, COBuilt 1955 · S/N 31607 N180MKCui Jin · Glendora, CAS/N 31409 N180MWGiles Richard E · Vass, NCBuilt 1956 · S/N 32490 N180NPoschwatta Jeffrey R · Kent, WABuilt 1954 · S/N 30889 N180NWStark James G · Cove, ORBuilt 1954 · S/N 31211 N180PHCornell David A · Palmer, AKBuilt 1955 · S/N 31455 N180PTProcaccini Donald P Jr · Spring Hill, FLBuilt 1954 · S/N 31051 N180PWHerrold Alvin J III · Seward, NEBuilt 1955 · S/N 31985 N180PXFloerke Keith Joseph Jr · Taft, TXS/N 31502 N180RDSchmid David J · Anchorage, AKBuilt 1955 · S/N 31613 N180RFSoloy Matthew C · Palmer, AKBuilt 1953 · S/N 30011 N180RJKindred David M · Soldotna, AKBuilt 1956 · S/N 32414 N180RXKaram John G · Reno, NVBuilt 1955 · S/N 31794 N180SBAzul Aviation LLC · Post Falls, IDBuilt 1955 · S/N 31405 N180SMSullivan Brandon M · Cloudcroft, NMBuilt 1953 · S/N 30442 N180SNNielson Donald L · Independence, ORS/N 32399 N180TFMontanelli Peter A · Anchorage, AKBuilt 1954 · S/N 31115 N180TKSeymour Laurie A · Marshfield, MABuilt 1953 · S/N 30214

Back to Cessna 180