Skip to content

Registered aircraft · 781

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

N2596LBurris Cale · Hardin, ILBuilt 1967 · S/N 17255796 N2600LN2600l LLC · Pageland, SCBuilt 1967 · S/N 17255800 N2601LCobb William J · Cincinnatus, NYBuilt 1967 · S/N 17255801 N2603LMagel David J · Lakemoor, ILBuilt 1967 · S/N 17255803 N2609LHavertown Flyers LLC · Havertown, PABuilt 1967 · S/N 17255809 N2613LOzark Aviators Inc · Willow Springs, MOBuilt 1967 · S/N 17255813 N2621LTailwinds Flying LLC · Cherokee Ridge, ALBuilt 1967 · S/N 17255821 N2623LAli Bryan N · Miami, FLBuilt 1967 · S/N 17255823 N2625LYezarski Edward J · Shirley, NYBuilt 1967 · S/N 17255825 N2628LBerg C Aaron · Driscoll, NDS/N 17255828 N2629LHein Merilee K · Mabel, MNBuilt 1967 · S/N 17255829 N2632LKelley James M · Greenwood, ARBuilt 1967 · S/N 17255832 N2634LMetal Mistress Aviation LLC · Meadowview, VABuilt 1967 · S/N 17255834 N2635LQueen Matthew E · Shenandoah, VAS/N 17255835 N2637LAustin Timothy · Abbeville, SCBuilt 1967 · S/N 17255837 N2638LMorgan Todd W · Roscoe, ILBuilt 1967 · S/N 17255838 N2641LTm Aviation Services LLC · Riverside, CABuilt 1967 · S/N 17255841 N2642LRiggin Flight Service Inc · Madison, SDS/N 17255842 N2645LMchugh Eric P · Cleveland, TXS/N 17255845 N2647LCommonwealth Aviation Services LLC · Herndon, VABuilt 1967 · S/N 17255847 N2648LZangs William J · Poplar Grove, ILBuilt 1967 · S/N 17255848 N2650LRholetter Eric W · Westminster, SCBuilt 1967 · S/N 17255850 N2651LJohnson Turner C II · England, ARBuilt 1967 · S/N 17255851 N2652LSullivan James M · East Wakefield, NHBuilt 1967 · S/N 17255852 N2654LGriner Carrie L · Auburndale, FLBuilt 1967 · S/N 17255854 N2656LSzymanski Alexander G · Hernando, MSBuilt 1967 · S/N 17255856 N2661LHall David B Jr · Midland City, ALBuilt 1967 · S/N 17255861 N2662LWaller Leslie P · Cynthiana, KYBuilt 1967 · S/N 17255862 N2665LKay Bennie L · Brigham City, UTBuilt 1967 · S/N 17255865 N2668LEnnis Shannon E · Chesapeake, VABuilt 1967 · S/N 17255868 N2669LRotormate LLC · Royse City, TXBuilt 1967 · S/N 17255869 N2670LOns Bart · Kirkland, WABuilt 1967 · S/N 17255870 N2671LNbl Aviation LLC · Woodway, TXBuilt 1967 · S/N 17255871 N2673LBalcom Terry J · Shepherd, MIBuilt 1967 · S/N 17255873 N2674LValley Excavation And Grading Inc · Chatsworth, CABuilt 1967 · S/N 17255874 N2675LFoster Jeffrey W · Lexington, NCBuilt 1967 · S/N 17255875 N2676LCupp Stanley J · Quilcene, WABuilt 1967 · S/N 17255876 N2679LBartley James K · Kent, WABuilt 1967 · S/N 17255879 N2682LCommonwealth Technical Services Inc · Powhatan, VABuilt 1967 · S/N 17255882 N2688LParsons Joshua A · Hollis Center, MES/N 17255888 N2695LHindberg Jacob W · Fisher, MNBuilt 1967 · S/N 17255895 N2696LPark Rapids Avionics Inc · Park Rapids, MNBuilt 1967 · S/N 17255896 N2699L98x LLC · Caddo Mills, TXBuilt 1967 · S/N 17255899 N2700LFly First LLC · West Memphis, ARBuilt 1967 · S/N 17255900 N2701LRegistration Pending · Los Angeles, CARegistration pendingBuilt 1967 · S/N 17255901 N2704LAgrifoglio Douglas · Reedley, CABuilt 1967 · S/N 17255904 N2708LRafter Jm Enterprises LLC · Swink, OKBuilt 1967 · S/N 17255908 N2709LGuideair LLC · Eden Prairie, MNBuilt 1967 · S/N 17255909 N2713LFlemmer Richard W · Park City, MTBuilt 1967 · S/N 17255913 N2715LGoebel Christian E · Luray, VABuilt 1967 · S/N 17255915

Back to Cessna 172H