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.

N6433EMorgan Peter F · Parma, IDBuilt 1959 · S/N 46533 N6435BCookson Brian E · Cookson, OKS/N 29635 N6435EForte Aviation Parts Inc · Fort Lauderdale, FLBuilt 1959 · S/N 46535 N6437BBrown Michael W · Merced, CABuilt 1956 · S/N 29637 N6437EFremont Flight Service LLC · Fremont, MIBuilt 1959 · S/N 46537 N6438BEllis Matthew P · Broken Arrow, OKBuilt 1957 · S/N 29638 N6439EBritt Thomas K · Riverview, FLBuilt 1959 · S/N 46539 N6441BSanpete Air LLC · Spring City, UTBuilt 1957 · S/N 29641 N6442EFat Bob Aviation Holdings LLC · Midland, MIBuilt 1959 · S/N 46542 N6444Pyne Robert B · Peyton, COBuilt 1958 · S/N 36816 N6446EEster Escape LLC · Hill City, SDBuilt 1959 · S/N 46546 N6447ELockwood Robert C Jr · Greenwell Springs, LABuilt 1959 · S/N 46547 N6448ELincoln Land Community College · Springfield, ILBuilt 1959 · S/N 46548 N6449EShamburek Steven J · Anchorage, AKBuilt 1959 · S/N 46549 N6451BWalker Robert C · Bend, ORBuilt 1957 · S/N 29651 N6451EBernaldt Lyndall W · Bartlesville, OKBuilt 1959 · S/N 46551 N6452ESorenson Farms Of Montana · Forsyth, MTBuilt 1959 · S/N 46552 N6453BHewitt Alan E · Renton, WABuilt 1957 · S/N 29653 N6453EMeeks William M III · Tulsa, OKBuilt 1959 · S/N 46553 N6454ERegistration Pending · Downey, CARegistration pendingS/N 46554 N6455BLala Princy Jairaj · Deltona, FLBuilt 1957 · S/N 29655 N6456BVintage Trainers Inc · Wilmington, DEBuilt 1956 · S/N 29656 N6457ENewell Michael S · Marion, OHBuilt 1959 · S/N 46557 N6458BChavez Lauren K Hollingsworth · Albuquerque, NMBuilt 1956 · S/N 29658 N6460BSchmick Kenneth R · Fond Du Lac, WIBuilt 1956 · S/N 29660 N6460EHooks Herbert D · Templeton, PAS/N 46560 N6464BResicum International LLC DBA · Gulf Shores, ALBuilt 1957 · S/N 29664 N6464EGeerlings Hillside Farms LLC · Holland, MIBuilt 1959 · S/N 46564 N6465BWetzel Kyle P · Carrington, NDBuilt 1957 · S/N 29665 N6465EBibeau Dave J · Longmeadow, MABuilt 1959 · S/N 46565 N6466ESloan Derwood D · Hurricane, WVBuilt 1959 · S/N 46566 N6467ELinton David J · Whitewater, WIBuilt 1959 · S/N 46567 N6468BBachman Airworks LLC · Spokane Valley, WABuilt 1956 · S/N 29668 N6470BSchlotte Randall V · River Falls, WIBuilt 1957 · S/N 29670 N6470ETaft Ernest F · Sunburst, MTBuilt 1959 · S/N 46570 N6471BCarney Calvin W · Portland, TNBuilt 1957 · S/N 29671 N6471EFratangelo Patricia L · Trumansburg, NYBuilt 1959 · S/N 46571 N6472EWomack Terry W · Prineville, ORS/N 46572 N6473BGriffin Robert T Jr · Scranton, PABuilt 1957 · S/N 29673 N6477ELoutzenhiser Mark · Wasilla, AKBuilt 1959 · S/N 46577 N6478BKuhfahl Matthew J · San Antonio, TXBuilt 1957 · S/N 29678 N6479EThomas Alan R · Wickenberg, AZBuilt 1959 · S/N 46579 N6480BCrowe Manoah R · Del Valle, TXFirst renewal noticeBuilt 1957 · S/N 29680 N6481BMorse Cory L · Montville, MEBuilt 1957 · S/N 29681 N6482BMendoza Victor · Liberal, KSS/N 29682 N6482EIreland Kel · Fredericksburg, TXBuilt 1959 · S/N 46582 N6485EWitte Steven E · Egan, SDBuilt 1959 · S/N 46585 N6486BDevine Aviation LLC · Atlanta, GABuilt 1956 · S/N 29686 N6487BOneal Gary · Springdale, ARBuilt 1957 · S/N 29687 N6488EDanielson Austin Mb · Kenai, AKBuilt 1959 · S/N 46588

Back to Cessna 172