Skip to content

Registered aircraft · 471

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

N2447UMccauley Stephen M · Buckley, WAS/N 17250047 N2447YNeu Aviation LLC · Benton, LABuilt 1962 · S/N 17249747 N2448YTennison William T · Osprey, FLBuilt 1962 · S/N 17249748 N2449UCurl Eric A · Olympia, WABuilt 1963 · S/N 17250049 N2453YNoteboom-Hegg LLC · Sioux Falls, SDBuilt 1962 · S/N 17249753 N2455YAircrafters French Valley Inc · Winchester, CABuilt 1962 · S/N 17249755 N2457YGhost Rider Aviation LLC · Yuma, AZS/N 17249757 N2458UEversoll Dennis D · Petersburg, INBuilt 1963 · S/N 17250058 N2458YArdmore Aviation LLC · Novelty, OHBuilt 1962 · S/N 17249758 N2459UHaynes Harrison F · Gainesville, GABuilt 1963 · S/N 17250059 N2461UHansen Aviation LLC · Savannah, GABuilt 1963 · S/N 17250061 N2461YIbx Living LLC · Wake Forest, NCBuilt 1962 · S/N 17249761 N2462UBixler Timothy · Wildwood, FLS/N 17250062 N2463CWofford Johnny A · Fort Davis, TXBuilt 1963 · S/N 17250569 N2463ULively Matt E · Aledo, TXBuilt 1963 · S/N 17250063 N2463YCaylin LLC · Wilmington, DEBuilt 1962 · S/N 17249763 N2464UFly By Faith LLC · Laurel Springs, NCBuilt 1963 · S/N 17250064 N2464YHogan Dale R · Monterey, CABuilt 1962 · S/N 17249764 N2466UHolloway Andrew · David City, NEBuilt 1963 · S/N 17250066 N2468URegistration Pending · Washington, WVRegistration pendingBuilt 1963 · S/N 17250068 N2469YStanphill David L · Stephenville, TXBuilt 1962 · S/N 17249769 N2470UT C I Aviators LLC · Lewes, DEBuilt 1963 · S/N 17250070 N2471YRegistered aircraftBuilt 1962 · S/N 17249771 N2474UPistor Elise D · Colleyville, TXBuilt 1963 · S/N 17250074 N2476UFive States Holdings LLC · Helena, MTBuilt 1963 · S/N 17250076 N2478UBraun Kevin J · Aberdeen, SDS/N 17250078 N2478YHockenson Roy D · Auburn, WABuilt 1962 · S/N 17249778 N2479U2479u Aviation LLC · Fernandina Beach, FLBuilt 1963 · S/N 17250079 N2479YDmac Aircraft LLC · Savannah, GABuilt 1962 · S/N 17249779 N2480URaczynski Adam · Far Rockaway, NYBuilt 1963 · S/N 17250080 N2481YFellers Farms LLC · Burlington, OKBuilt 1962 · S/N 17249781 N2484UFiske James K · North Andover, MABuilt 1963 · S/N 17250084 N2485YMcdonald Gregory S · Mena, ARBuilt 1962 · S/N 17249785 N2486YCarfinder LLC · Huntington Station, NYBuilt 1962 · S/N 17249786 N2487UBaske Scott E · Hanna, INBuilt 1963 · S/N 17250087 N2487YBradley Jeff C · Schertz, TXS/N 17249787 N2488USchafer Gerhard Walter · Fairbanks, AKS/N 17250088 N2489UKauachi Melik · Brownsville, TXS/N 17250089 N2490UBredbenner Carl A · Dalmatia, PABuilt 1963 · S/N 17250090 N2493YBeauchamp Chris L · Anacortes, WABuilt 1962 · S/N 17249793 N2495UKoelbl Aviation LLC · Whitesboro, TXBuilt 1963 · S/N 17250095 N2496UKloker Daniel E · Owasso, OKBuilt 1963 · S/N 17250096 N2496YSchwab George E · Stillwater, OKBuilt 1962 · S/N 17249796 N2497YSouth Plains Precision Ag · Plainview, TXBuilt 1962 · S/N 17249797 N2498URegistration Pending · Royal, ARRegistration pendingBuilt 1963 · S/N 17250098 N2498YBargabos Earthworks Inc · Peterboro, NYBuilt 1962 · S/N 17249798 N2499YTompos Michael J · Mendota Heights, MNBuilt 1962 · S/N 17249799 N2500XHolloway James H · Merritt Island, FLBuilt 1962 · S/N 17249800 N2501ULarkin Edmund V · Bogart, GABuilt 1963 · S/N 17250101 N2502UChristensen Alan B · Murphysboro, ILBuilt 1963 · S/N 17250102

Back to Cessna 172D