Skip to content

Piper PA-24-180

Registered aircraft · 196

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

N111DTInternational Air Services Inc Trustee · Carson City, NVBuilt 1960 · S/N 24-2260 N180PHd Utilities And Grading LLC · La Vista, NES/N 24-2074 N1LRFoster Darrell R · Hickory, NCBuilt 1960 · S/N 24-2274 N311SSSeabolt Pilots LLC · Cave City, ARBuilt 1960 · S/N 24-1959 N5011PFinkey Jason B · Leonidas, MIBuilt 1958 · S/N 24-14 N5018PTseng Leon Y · Tucson, AZBuilt 1958 · S/N 24-21 N5024PSun Aviation Inc · Santa Clara, CABuilt 1958 · S/N 24-27 N5033PHouser Kyler D · West New York, NJBuilt 1958 · S/N 24-36 N5038PMidyett Charles O · Cambridge, MDBuilt 1958 · S/N 24-41 N5046PSchwerin Stan M · Walla Walla, WABuilt 1958 · S/N 24-50 N5047PBeckwith Rodney J III · Howell, MIBuilt 1958 · S/N 24-51 N5049PByers David R · Franklin, INBuilt 1958 · S/N 24-53 N5053PCc Aviation Inc · Discovery Bay, CABuilt 1958 · S/N 24-58 N5056PHfc Inc · Halma, MNBuilt 1958 · S/N 24-61 N5072PCappurccini Alfred II · Pittsburgh, PABuilt 1958 · S/N 24-78 N5082PShaw Jeryl V · Arcata, CABuilt 1958 · S/N 24-88 N5110PGray William · Broken Arrow, OKBuilt 1958 · S/N 24-120 N5119PWood John W · Toccoa, GABuilt 1958 · S/N 24-132 N5125PWalton Josh A · Westcliff, COBuilt 1958 · S/N 24-138 N5133PMoore Buck B · Wasco, CABuilt 1958 · S/N 24-146 N5146PRenton Russell S · Whitestown, INBuilt 1958 · S/N 24-162 N5168PCreegan John T Jr · Dundee, ILBuilt 1958 · S/N 24-185 N5177PLi Steven Y · Warren, NJBuilt 1958 · S/N 24-197 N5198PBrooks Larry D · Ramona, OKBuilt 1958 · S/N 24-222 N5267PCarter Jeffrey Lee · Cameron Park, CABuilt 1958 · S/N 24-303 N5308PRegistered aircraftBuilt 1958 · S/N 24-349 N5314PStaiger John L III · Saint Clair, MIBuilt 1958 · S/N 24-355 N5367PBerg Robert M · Culver, ORS/N 24-416 N5390PHankins Jon A · Fort Mohave, AZBuilt 1958 · S/N 24-441 N5401PCook Leo Marshall · Lincoln, CABuilt 1958 · S/N 24-455 N5433PStephens Matthew T · Ocean Springs, MSBuilt 1958 · S/N 24-487 N5511PGear Down Hangar LLC · Phoenix, AZBuilt 1958 · S/N 24-574 N5520POdonnell Nathan Ray · Enterprise, ALBuilt 1958 · S/N 24-583 N5565PGrant Zachary J · Indianapolis, INBuilt 1958 · S/N 24-629 N5574PPluck Mervyn M · Glendora, CABuilt 1958 · S/N 24-638 N5594PBombo Aviation LLC · Gold Beach, ORBuilt 1959 · S/N 24-661 N5595PCassell Joseph · Singer, LABuilt 1959 · S/N 24-662 N5605PAurnou Marshall E · Marco Island, FLBuilt 1959 · S/N 24-673 N5633PPride Lawrence E · Poway, CABuilt 1959 · S/N 24-703 N5636PBarley Austin D · Red Lion, PABuilt 1959 · S/N 24-706 N5639PMarchetti Nancy K · Port Charlotte, FLS/N 24-709 N5649PTalarek Kai C · Far Hills, NJBuilt 1959 · S/N 24-720 N5662PSullivan Anthony J · Snohomish, WABuilt 1959 · S/N 24-734 N5665PLangevin Michael · Anchorage, AKS/N 24-737 N5666PChrysoar Group LLC · King George, VABuilt 1959 · S/N 24-738 N5677PMourouzis Jack · Indianapolis, INBuilt 1959 · S/N 24-749 N5685PWalker Richard E · Quanah, TXBuilt 1959 · S/N 24-757 N5689PMarsala Joseph · Uxbridge, MABuilt 1959 · S/N 24-761 N5706PAldredge J Ralph · Milner, GABuilt 1959 · S/N 24-779 N5719PPulkrabek David · Hutchinson, MNBuilt 1959 · S/N 24-793

Back to Piper PA-24-180