Skip to content

Registered aircraft · 1,805

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

N7476ARedd Michael L · Harrisburg, ARBuilt 1956 · S/N 29576 N7478AColorado Air Ventures LLC · Colorado Springs, COBuilt 1956 · S/N 29578 N747PBBromley James B II · Hesperia, MIBuilt 1956 · S/N 28846 N7480APacific Ag Services · Firebaugh, CABuilt 1957 · S/N 29580 N7481AGrocholl Mark · Rockton, ILBuilt 1956 · S/N 29581 N7485APrecup Michael P Sr Trustee · Perrysville, OHBuilt 1956 · S/N 29585 N7487ANelson Rodney G · Amenia, NDBuilt 1957 · S/N 29587 N7489AAllianna LLC · Fayetteville, ARBuilt 1956 · S/N 29589 N7491AMckee Paul R · Astoria, ORBuilt 1957 · S/N 29591 N7496AMcreynolds Sean D · Visalia, CABuilt 1956 · S/N 29596 N7497AJohnson Kurt W · Jordan, MNBuilt 1956 · S/N 29597 N7498ATorrey Robert S · Anchorage, AKBuilt 1957 · S/N 29598 N7499ADurousseau Joseph Harry Trustee · Sparks, NVBuilt 1957 · S/N 29599 N7564TRegistration Pending · Phoenix, AZRegistration pendingBuilt 1959 · S/N 47164 N7590TDauteuil Rodney A · Salem, NHBuilt 1959 · S/N 47190 N7643TGarcia Yonhara Fortun Faedo · Norco, CABuilt 1960 · S/N 47243 N777CASwamp Skies LLC · North Miami, FLS/N 17268259 N77FWBrooks Dylan · Anchorage, AKS/N 47409 N77KBBears Tooth Resources LLC · Red Lodge, MTBuilt 1957 · S/N 36214 N7812TCurzon John R · Brookings, ORS/N 47412 N7889THele Lani LLC · Mililani, HIS/N 47489 N7901BCantrell Dennis · Conway, ARBuilt 1957 · S/N 29701 N7903BHenderson Ethan D · Argyle, NYBuilt 1957 · S/N 29703 N7904BWagoner Darrin G · Red Oak, TXBuilt 1957 · S/N 29704 N7908BFrancis James E · King City, CABuilt 1957 · S/N 29708 N7910BJohnson John A Trustee · Sandy, ORBuilt 1957 · S/N 29710 N7911BDaugherty Monte R · Anderson, INBuilt 1957 · S/N 29711 N7913BLand Terry · Adamstown, MDBuilt 1957 · S/N 29713 N7915BGriesman Scott W · Sandy Valley, NVS/N 29715 N7920BThompson Deven B · Richland, ORBuilt 1957 · S/N 29720 N7922BManley Ronnie H · Belleville, MIBuilt 1957 · S/N 29722 N7925BBache Harold F II · Gainesville, GAS/N 29725 N7926BRussellaire LLC · Holt, FLBuilt 1957 · S/N 29726 N7928BDawson Lynn M · The Villages, FLBuilt 1957 · S/N 29728 N7929BEvergreen Recreation Club Inc · Gainesville, TXBuilt 1957 · S/N 29729 N7930BWurtz Jakie Jr · Redfield, SDBuilt 1957 · S/N 29730 N7933BHudson Charles P · Sumrall, MSBuilt 1957 · S/N 29733 N7935BCollins Timothy L · Caldwell, IDBuilt 1957 · S/N 29735 N7939BChristmas Gabriel K · Fairbanks, AKBuilt 1956 · S/N 29739 N7940BHerbert Khristopher L · Tulsa, OKBuilt 1957 · S/N 29740 N7941BTetrahedron LLC · Layton, UTS/N 29741 N7942BPuckett Jeffrey F · Rector, ARBuilt 1957 · S/N 29742 N7943BMoul Dale E · Boise, IDBuilt 1956 · S/N 29743 N7944BHarms Steven Lee · Cedar Rapids, IABuilt 1957 · S/N 29744 N7946BBrock Raymond Richard · Crescent, IAS/N 29746 N7947BJames Bobby F · Bloomfield, INBuilt 1957 · S/N 29747 N7948BGruber Barbara L · Centreville, VABuilt 1957 · S/N 29748 N7949BHeffron Jacob L · Little Falls, MNS/N 29749 N7950BBobka Christian · Apple Valley, MNBuilt 1957 · S/N 29750 N7951BRocky Creek Jbd Inc · Boca Grande, FLBuilt 1957 · S/N 29751

Back to Cessna 172