Skip to content

Registered aircraft · 537

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

N7647MHeithold Burdett D · South Sioux City, NES/N 55947 N7652MHenderson Aviation LLC · Norman, OKBuilt 1959 · S/N 55952 N7656MSparrowhawk Aviation · Manvel, TXFirst renewal noticeBuilt 1959 · S/N 55956 N7661MPaul Gregory A · Overland Park, KSBuilt 1959 · S/N 55961 N7663MRashid Shahn S · Clear, AKBuilt 1959 · S/N 55963 N7664MMalinchak Louis Jr · Bristow, OKBuilt 1959 · S/N 55964 N7667MGier James C · Belgrade, MTBuilt 1959 · S/N 55967 N7668MNeal Daniel L · Morgan Hill, CABuilt 1959 · S/N 55968 N7669M95 Contracting LLC · Leander, TXBuilt 1959 · S/N 55969 N7671MWarren Robert Scott · Harrisburg, NCBuilt 1959 · S/N 55971 N7674MMezzell James H · Cullman, ALBuilt 1959 · S/N 55974 N7676MWhite Hawk Leasing LLC · Chapel Hill, NCS/N 55976 N7679MRothgeb Michael A · Burns, ORBuilt 1959 · S/N 55979 N7682MVan De Hei Mike · Pioneer, CABuilt 1959 · S/N 55982 N7683MHarmon Katlyn E · Gypsum, COS/N 55983 N7687MMckown Kevin · Edgewood, NMS/N 55987 N7688MCampbell Ronald M · Upland, CABuilt 1959 · S/N 55988 N7689MMoreland Wesley · Mckinney, TXBuilt 1959 · S/N 55989 N7691MKoch Doug L · Wentworth, SDBuilt 1959 · S/N 55991 N7692MMeyer Lynn O · Olathe, KSBuilt 1959 · S/N 55992 N7693MBaumann William E · Eureka, NVBuilt 1959 · S/N 55993 N7695MOboyle Thomas R · Manhattan, KSBuilt 1959 · S/N 55995 N7696MForchtner Thomas J · Oklahoma City, OKBuilt 1959 · S/N 55996 N76MAAnderson Daniel J · Campbellsport, WIFirst renewal noticeBuilt 1959 · S/N 55892 N777ADLeithead Bruce O · Stone Mountain, GABuilt 1958 · S/N 55502 N817AKZweifel Brad · Palmer, AKBuilt 1958 · S/N 55101 N8274TTraylor Robert B · Millersview, TXS/N 17556974 N827VPClik Services LLC · Forestdale, MABuilt 1959 · S/N 55840 N831NCCole Curtis J · Loveland, COBuilt 1958 · S/N 55432 N8881Steadfast Ministries · Alton, TXS/N 55308 N9204BMcelwain Floyd · Saint Joseph, MOBuilt 1958 · S/N 55004 N9208BYoung James A · Toledo, WABuilt 1958 · S/N 55008 N9212BRegistration Pending · Campbellsville, KYRegistration pendingBuilt 1958 · S/N 55012 N9213BWallace Gary E · La Junta, COS/N 55013 N9218BWilliams Leslie D · Oneida, TNBuilt 1958 · S/N 55018 N9222BGilreath Steven M · Anderson, SCBuilt 1958 · S/N 55022 N9225B25/25 LLC · Pinedale, WYBuilt 1958 · S/N 55025 N9232BLaird Charles L · Adelanto, CABuilt 1958 · S/N 55032 N9233BHiggins Kenneth James II · Dawsonville, GABuilt 1958 · S/N 55033 N9235BOn A Lark LLC · Post Falls, IDBuilt 1958 · S/N 55035 N9237BMenard Keith L · Bellevue, TXS/N 55037 N9245BHitt Lonnie D · Gatesville, TXBuilt 1958 · S/N 55045 N9248BJackalope Aviation LLC · Bellingham, WABuilt 1958 · S/N 55048 N9249BCoull Jennifer · Easton, PABuilt 1958 · S/N 55049 N9251BBurke Charles M · Ocala, FLFirst renewal noticeBuilt 1958 · S/N 55051 N9252BSwain Raymond B · Mansfield, TXBuilt 1958 · S/N 55052 N9254BMcdonald Daniel R · Las Vegas, NVBuilt 1958 · S/N 55054 N9256BDillard Wendell Hoyt · Centerville, TXBuilt 1958 · S/N 55056 N9269BHaataja Charles M · Two Rivers, WIBuilt 1958 · S/N 55069 N9272BGyhra Bradley · Phenix City, ALBuilt 1958 · S/N 55072

Back to Cessna 175