Skip to content

Registered aircraft · 1,111

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

N64943Tipton Donald Jeffrey Sr · Maryville, TNBuilt 1982 · S/N 17275657 N64962Wingsleasing LLC · Wichita, KSBuilt 1982 · S/N 17275659 N64964Dodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275660 N64966Hill Mark T · Gloucester, VABuilt 1982 · S/N 17275661 N64972Fixed Wing Holding Company Inc · Pembroke Pines, FLS/N 17275662 N64CASwaz Aviation LLC · Mesa, AZBuilt 1981 · S/N 17275269 N65001Dornak Henry E Jr · Corpus Christi, TXBuilt 1982 · S/N 17275665 N65003Major Air LLC · Charleston, SCBuilt 1982 · S/N 17275666 N65021Borda Anthony J · West Chester, PABuilt 1982 · S/N 17275670 N65032Vavrek Holly Kay · Palm City, FLBuilt 1982 · S/N 17275672 N65040Mc Creery Aviation Co Inc · Mcallen, TXS/N 17275673 N65045Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1982 · S/N 17275674 N65057Good Winds LLC · Waterville, MEBuilt 1982 · S/N 17275677 N65058Organization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1982 · S/N 17275678 N65065Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275681 N6508KTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274205 N65107Renforth Michael E · Yorktown, VABuilt 1982 · S/N 17275686 N65112Jav Air Services LLC · Anchorage, AKS/N 17275688 N6512KLoomis Aviation LLC · Columbus, OHBuilt 1980 · S/N 17274206 N65180Mccraw Bryan · Telephone, TXBuilt 1982 · S/N 17275702 N65191Bampton Dennis · Portage Des Sioux, MOBuilt 1982 · S/N 17275705 N65192Tactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 1982 · S/N 17275706 N65197Aviator Education LLC · Greeley, COBuilt 1972 · S/N 17275707 N65221Wings Over Texas Holdings LLC · Denton, TXBuilt 1982 · S/N 17275711 N65259Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1982 · S/N 17275715 N65275Registered aircraftBuilt 1982 · S/N 17275719 N65276Christiansen Aviation LLC · Wilmington, DEBuilt 1982 · S/N 17275720 N65295Northwoods Air LLC · Orono, MEBuilt 1982 · S/N 17275723 N6544KWaldron Ronald J · Strongsville, OHBuilt 1980 · S/N 17274209 N65489Flight Solutions LLC · Columbia, MOBuilt 1982 · S/N 17275762 N65516J-Airco LLC · Nashville, TNBuilt 1982 · S/N 17275769 N65518Tk Equipment LLC · Brownsburg, INBuilt 1982 · S/N 17275771 N65525Sinha Nanda K · Benicia, CABuilt 1982 · S/N 17275774 N65528Jacks Charles D · Crowley, LABuilt 1983 · S/N 17275775 N6553KSchaffner Christopher · Dunmore, WVBuilt 1980 · S/N 17274211 N65587Wings Over Texas Holdings LLC · Denton, TXBuilt 1982 · S/N 17275780 N65614American Patrols Inc · Midland, TXBuilt 1982 · S/N 17275785 N65620Condair Flyers Inc · Latham, NYBuilt 1982 · S/N 17275787 N65623Hoffman William C · Mount Pleasant, PABuilt 1982 · S/N 17275788 N65624Carver Clarence K · Lutz, FLBuilt 1982 · S/N 17275789 N65626Smith Terry G · Liberty Twp, OHBuilt 1982 · S/N 17275790 N65628Circle Nineteen Aviation LLC · Burlington, CTBuilt 1982 · S/N 17275791 N65645Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1982 · S/N 17275797 N65658L A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275804 N65665Tomolonius Nathan · Newington, CTBuilt 1982 · S/N 17275810 N65673Middletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1982 · S/N 17275814 N65690690 LLC · Carmel, INBuilt 1982 · S/N 17275820 N65697Kemp Alan R · Niobrara, NEBuilt 1982 · S/N 17275821 N65698Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275822 N656MFMelbourne Flight Training LLC · Melbourne, FLBuilt 1982 · S/N 17275818

Back to Cessna 172P