Skip to content

Registered aircraft · 617

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

N3568SKnitter Edward R III · Perry, NYBuilt 1963 · S/N 17250768 N3570SVance Douglas E · Cleveland, GABuilt 1963 · S/N 17250770 N3571SGoodman James L · Wray, GABuilt 1963 · S/N 17250771 N3572SWeidman Paul D · Lebanon, PABuilt 1963 · S/N 17250772 N3576SGarrison Jerry L · Leavenworth, KSBuilt 1963 · S/N 17250776 N3577STorman Kevin B · Umatilla, FLBuilt 1963 · S/N 17250777 N3578SHigley Jon · Jerome, IDS/N 17250778 N3582SMcmath Albert J Jr · Onley, VABuilt 1963 · S/N 17250782 N3583SWalls Jerry L · Hawley, TXBuilt 1963 · S/N 17250783 N3584SPaul Aviation LLC · Wasco, CABuilt 1963 · S/N 17250784 N3585SNorman Jon D · Plainwell, MIBuilt 1963 · S/N 17250785 N3587SRegistered aircraftAssigned, pending cancellationS/N 17250787 N3589SErickson Miles · Langley, WABuilt 1963 · S/N 17250789 N3590SNorthwest Aircraft Services LLC · Hayden, IDS/N 17250790 N3591SPitt Kenneth · Paonia, COBuilt 1963 · S/N 17250791 N3595SBarnett Carl Chris · Todd, PABuilt 1963 · S/N 17250795 N3597SHawkins Ronald Lee · Vancouver, WABuilt 1963 · S/N 17250797 N3599SRichner Dennis M · Andover, MNBuilt 1963 · S/N 17250799 N3600SRussell Scott Marvin · Sanger, TXBuilt 1963 · S/N 17250800 N3603SBetter Fly Inc · Litchfield, ILBuilt 1963 · S/N 17250803 N3609SSchuerch Vincent M · Wasilla, AKBuilt 1963 · S/N 17250809 N3611SCombs Charles M · Mesa, AZS/N 17250811 N3613SMccomb Charles D · Cypress, TXBuilt 1963 · S/N 17250813 N3615SBlacqjacq Aviation Co · Wilmington, DEBuilt 1963 · S/N 17250815 N3616SArtisan Outreach LLC · Dunnellon, FLBuilt 1964 · S/N 17250816 N3619SFitch Aviation Holdings LLC · Pottsboro, TXBuilt 1963 · S/N 17250819 N3620SBoese Howard · Brownell, KSBuilt 1963 · S/N 17250820 N3621SAlletto Alexander J · Russell Springs, KYBuilt 1964 · S/N 17250821 N3622SMichael Lewis R · Big Rapids, MIS/N 17250822 N3628SWright Way Air Venture LLC · Westville, INBuilt 1963 · S/N 17250828 N3629SBradley Christopher J · Left Hand, WVBuilt 1963 · S/N 17250829 N3630SFly Dogs LLC · Sunbury, OHBuilt 1963 · S/N 17250830 N3631SJust Plane Fun 9m6 LLC · Lake Providence, LABuilt 1963 · S/N 17250831 N3636SGriesman Scott W · Sandy Valley, NVBuilt 1963 · S/N 17250836 N3640SPetersen Jacob R · Wasilla, AKS/N 17250840 N3643SMaycroft David · Cary, ILBuilt 1963 · S/N 17250843 N3644SMurray William · East Jordan, MIBuilt 1963 · S/N 17250844 N364SRSales Joe H DBA · Seminole, TXBuilt 1964 · S/N 17251558 N3656SBell Michael L · Spokane, WAS/N 17250856 N3657SIsakson Dennis E · Van Tassell, WYBuilt 1963 · S/N 17250857 N3658SOrlovich John A · Boise, IDS/N 17250858 N3659SWeed Thomas W · Limington, MEBuilt 1963 · S/N 17250859 N3661SMiller Harvey L · Livonia, MIBuilt 1963 · S/N 17250861 N3663SFranks Richard W · Moville, IAS/N 17250863 N3664SWasson Tom L · Lakeport, CABuilt 1963 · S/N 17250864 N3666SBerry Mike J · Palo Cedro, CABuilt 1963 · S/N 17250866 N3667SOliva Louis F III · Anchorage, AKS/N 17250867 N3668SWm Aviation LLC · Moncks Corner, SCBuilt 1963 · S/N 17250868 N3669SKeller Kenneth Ray Jr · Jonesboro, ARS/N 17250869 N3673SMike Whiskey LLC · Le Claire, IABuilt 1963 · S/N 17250873

Back to Cessna 172E