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.

N6778AQuadrani Anthony · Kingsford, MIBuilt 1956 · S/N 28878 N6779ASpanbauer Paul J · Oshkosh, WIS/N 28879 N6784AAtlantic Rotors LLC · Saint Inigoes, MDBuilt 1956 · S/N 28884 N6786ARutledge Brett B · Yuma, COS/N 28886 N6789AChris Fuher Flight Instruction LLC DBA · Townsend, MTS/N 28889 N678KPalm Steven · Madera, CABuilt 1956 · S/N 29454 N6790ALaurel 406 Aero · Billings, MTS/N 28890 N6793AJones Jeffrey D Trustee · Elida, OHBuilt 1956 · S/N 28893 N6795AKelley Aviation Services Inc · Halifax, PAFirst renewal noticeBuilt 1956 · S/N 28895 N6796AAjer Richard L · Herriman, UTBuilt 1956 · S/N 28896 N6800APilots You Can Trust LLC · Fayetteville, NCBuilt 1956 · S/N 28900 N6802AAeromasters Inc · Surgoinsville, TNBuilt 1956 · S/N 28902 N6804AObrien Christopher A · Juneau, AKBuilt 1956 · S/N 28904 N6807ANelson Jason P · Childress, TXBuilt 1956 · S/N 28907 N6808AShaak John C · Newnan, GABuilt 1956 · S/N 28908 N6809ACottrell Lee D · Brownfield, TXBuilt 1956 · S/N 28909 N6812AMoores Aerospace Solutions LLC · Statesboro, GABuilt 1956 · S/N 28912 N6813ADenman David H · Gainesville, FLBuilt 1956 · S/N 28913 N6815AN6815a LLC · Allegan, MIBuilt 1956 · S/N 28915 N6817ACerminara Giovanni · Belleview, FLBuilt 1956 · S/N 28917 N681RLWeatherby Thomas M · Rcho Sta Marg, CAS/N 28633 N6821AArmiger Scott Linwood · Holly Springs, NCBuilt 1956 · S/N 28921 N6822AStewart Brock Allen · Bartlett, TNBuilt 1956 · S/N 28922 N6823AWilliams Daniel H · Fort Mcdowell, AZBuilt 1956 · S/N 28923 N6824AChristenson Robert E · Anacortes, WABuilt 1956 · S/N 28924 N6825ABarker Jason · Hampton Falls, NHBuilt 1956 · S/N 28925 N6829ABaker Elbert W · Beckley, WVBuilt 1956 · S/N 28929 N6830ALange Cole K · Oglala, SDBuilt 1956 · S/N 28930 N6831ASale Reported · Pullman, WASale reportedS/N 28931 N6833AChapter 163 Flying Club · Las Vegas, NVBuilt 1956 · S/N 28933 N6835ABaratka Darin W · Phillips, WIBuilt 1956 · S/N 28935 N6836ARiner Mark G · Bartlesville, OKBuilt 1956 · S/N 28936 N6837ANorth Nathan A · Damascus, MDBuilt 1956 · S/N 28937 N6840AMcnaught Scott S · Winlock, WABuilt 1956 · S/N 28940 N6841ASmooth Flying LLC · Barnwell, SCBuilt 1956 · S/N 28941 N6847AEwald Christopher Robert · Blanding, UTBuilt 1956 · S/N 28947 N6852AFabian Ryan S · Vancouver, WABuilt 1956 · S/N 28952 N6854ADulin Thad L · Midland, TXBuilt 1956 · S/N 28954 N6855ACowley Dale Thomas Trustee · Sandusky, MIS/N 28955 N6858ACorrigan Flying Club · Manitowoc, WIBuilt 1956 · S/N 28958 N6859AClark Brenton J · Fairfield, IAFirst renewal noticeS/N 28959 N6863AZinter Dean K · Tigard, ORBuilt 1956 · S/N 28963 N6864ABrusik John A Jr DBA · New Port Richey, FLS/N 28964 N6866AJlk Inc · Malvern, ARBuilt 1956 · S/N 28966 N6867AHeffron Jacob L · Little Falls, MNS/N 28967 N6869AMccraney John K · Canon, GAS/N 28969 N6871AGibson James G · Harpers Ferry, WVBuilt 1956 · S/N 28971 N6872ACoats Alexander · Murrieta, CAS/N 28972 N6874AGillum Thomas W III · Davenport, IABuilt 1956 · S/N 28974 N6877ASchenck Alan E · Clarinda, IABuilt 1956 · S/N 28977

Back to Cessna 172