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.

N488WMMackey Ken G · Ridgeville, SCS/N 36266 N5000AOzment Dennis W · Palmyra, MOBuilt 1955 · S/N 28000 N5001ADavis Anthony S · Homeland, CABuilt 1955 · S/N 28001 N5002ABrown Richard J · Lexington, TNS/N 28002 N5003AOverton Tommy D Sr · Clinton, LABuilt 1955 · S/N 28003 N5004AMoore Kelly N · Anchorage, AKBuilt 1955 · S/N 28004 N5005AWood Ryan H · Anchorage, AKBuilt 1955 · S/N 28005 N5006ASmokovitz Joseph M · Tecumseh, MIBuilt 1956 · S/N 28006 N5007AWallace Christopher S H · Cleburne, TXBuilt 1955 · S/N 28007 N5009AOgorek Peter J · Milwaukee, WIBuilt 1955 · S/N 28009 N5011ABores Scott J · Huron, OHS/N 28011 N5013AReed Ted R · San Angelo, TXBuilt 1955 · S/N 28013 N5016AMoore Wallace Frank · Mckinney, TXBuilt 1955 · S/N 28016 N5017AMeixell David Matthew · Santa Maria, CABuilt 1955 · S/N 28017 N5018ABadger Daniel J · Yellow Springs, OHS/N 28018 N5024ADucharme Matthew B · Harlem, GABuilt 1955 · S/N 28024 N5028AVonszilassy Peter · Fredericksburg, VABuilt 1955 · S/N 28028 N5031AEggum Jeramy J · Puyallup, WABuilt 1955 · S/N 28031 N5033AAloof Aviation LLC · Denver, COBuilt 1955 · S/N 28033 N5039ASutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 28039 N503ETar Dennis W · Summerfield, NCBuilt 1956 · S/N 28361 N5040APark Kyle Hunter · Jefferson City, MOS/N 28040 N5041AMccollough Bruce S · Skandia, MIBuilt 1955 · S/N 28041 N5043AStephens Zachary L · Big Lake, AKS/N 28043 N5044APatzanakidis Konstandinos · Jupiter, FLBuilt 1955 · S/N 28044 N5046AHappy Landings Aviation LLC · Maple, NCBuilt 1955 · S/N 28046 N5047AAeroslat4 LLC · Lewes, DEBuilt 1955 · S/N 28047 N5050ACampbell Barry A · Rogersville, TNBuilt 1955 · S/N 28050 N5053AKing David · Frisco, COBuilt 1955 · S/N 28053 N5054AGrimmonpre Gary · Huntley, ILBuilt 1955 · S/N 28054 N5055AN5055a LLC · Clayton, GABuilt 1955 · S/N 28055 N5057ASoar Above Flight Solutions LLC · Englewood, TNBuilt 1955 · S/N 28057 N5058ABeiter John A · Cle Elum, WABuilt 1955 · S/N 28058 N5059ASmith Rickey A · Divernon, ILS/N 28059 N505JJAero Davis LLC · Camden, DEBuilt 1958 · S/N 46086 N5061ASmith Aviation LLC · Springer, OKS/N 28061 N5066AThordarson Norman K · Friday Harbor, WABuilt 1955 · S/N 28066 N5067ADaniels Tim · Unalakleet, AKBuilt 1955 · S/N 28067 N5069ANusz Russell I · Hitchcock, OKBuilt 1953 · S/N 28069 N5071AMccanles Mike E · Adrian, MOBuilt 1955 · S/N 28071 N5072AGibbs James P · Boerne, TXS/N 28026 N5077APut Willem Albert · Birmingham, ALBuilt 1955 · S/N 28077 N5078ASmith Sidney R · Rllng Hls Est, CABuilt 1955 · S/N 28078 N5080ACoughlan Sally G · Bigfork, MTBuilt 1955 · S/N 28080 N5081AJones William H Trustee · Wenden, AZBuilt 1955 · S/N 28081 N5082AYoung Ryan E · Willis, TXBuilt 1955 · S/N 28082 N5084AOsterberg Douglas L · Neenah, WIBuilt 1955 · S/N 28084 N5087AMenard Bernny · Abbeville, LABuilt 1955 · S/N 28087 N5088APieper Mike D · Chandler, OKS/N 28088 N5089ABagley James R · Twentynine Palms, CABuilt 1955 · S/N 28089

Back to Cessna 172