Skip to content

Registered aircraft · 3,572

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

N13479Hendricks Field Aviation LLC · Sebring, FLBuilt 1973 · S/N 17262781 N13481Moreland David W · Fort Payne, ALBuilt 1973 · S/N 17262783 N13483Walk Michael · Englewood, FLFirst renewal noticeBuilt 1973 · S/N 17262784 N13486Anderson Joel M · Starkweather, NDBuilt 1973 · S/N 17262787 N13489Baby Balou Flyers LLC · Marysville, WABuilt 1973 · S/N 17262789 N13492Hausteen Karen Grace · New River, AZBuilt 1973 · S/N 17262790 N13494Landry Jeremy · Thibodaux, LABuilt 1973 · S/N 17262792 N13504Brewer Ruthie C · Wendell, NCBuilt 1973 · S/N 17262801 N13506Asberry Gregg · Sidney, ARBuilt 1973 · S/N 17262803 N13507Torell Pamela O · Port St Lucie, FLBuilt 1973 · S/N 17262804 N13508Labrador Aviation LLC · Barboursville, VABuilt 1973 · S/N 17262805 N13513Stella Luna Aviation LLC · Olive Branch, MSBuilt 1973 · S/N 17262810 N1351UThomas Jackson Smith · Baton Rouge, LAS/N 17267022 N13521Ekberg Jeff M · Emmett, IDS/N 17262817 N13522Recker Edward J · Surprise, AZBuilt 1973 · S/N 17262818 N13524Loomis Avaition LLC · Columbus, OHBuilt 1973 · S/N 17262820 N13527Beekman Gary J · Oconto, WIBuilt 1973 · S/N 17262823 N13529Meyer Ricky L · New Liberty, IABuilt 1973 · S/N 17262825 N1352UN19630 LLC · Fort Collins, COBuilt 1976 · S/N 17267023 N13535Aviation Academy LLC · Wichita, KSS/N 17262830 N13537Sale Reported · Brownsville, ORSale reported, pending cancellationBuilt 1973 · S/N 17262832 N13539Pawul Frank A · Graham, WABuilt 1973 · S/N 17262833 N1353UReynolds Darryl G · Wills Point, TXBuilt 1976 · S/N 17267024 N13540Spangler Taylor L · Andover, KSBuilt 1973 · S/N 17262834 N13543Skylink II LLC · Florissant, MOBuilt 1973 · S/N 17262836 N13544Registered aircraftBuilt 1973 · S/N 17262837 N13548Havana Flyers Assoc · Petersburg, ILBuilt 1973 · S/N 17262840 N13549Big Sky Communication & Cable Inc · Billings, MTBuilt 1973 · S/N 17262841 N1354UVosskuhler Darlene Duke · Sun City West, AZBuilt 1976 · S/N 17267025 N13551Eagle Sky Patrol Inc · Deadwood, SDBuilt 1973 · S/N 17262843 N13552Newton Property Leasing LLC · Greene, IABuilt 1973 · S/N 17262844 N13555Krueger Steven T · Leander, TXBuilt 1973 · S/N 17262846 N13558Seitz Dennis · Wausau, WIBuilt 1973 · S/N 17262847 N13559Bauta Carlos L · Bristol, INBuilt 1973 · S/N 17262848 N1356UN1356u LLC · Wilmington, DEBuilt 1976 · S/N 17267027 N13573Davis Flying Services LLC · Gaithersburg, MDBuilt 1973 · S/N 17262856 N1357UHarte Ryan D · Lone Star, TXBuilt 1976 · S/N 17267028 N13586Oreilly Thomas P · Oscoda, MIBuilt 1973 · S/N 17262860 N13587Nasairs Flying Club · Strongsville, OHBuilt 1973 · S/N 17262861 N1358UWaddill Paula J · Puryear, TNBuilt 1976 · S/N 17267029 N13590Habibelahian Hamid Reza · Jefferson, TXS/N 17262863 N13593Absolute Altitude LLC · Murrieta, CABuilt 1973 · S/N 17262866 N13594Chambers Quentin S · Bellingham, WABuilt 1973 · S/N 17262867 N1359UHokie Flying Club Inc · Christiansburg, VABuilt 1976 · S/N 17267030 N135ESport Flying USA Inc · Ronkonkoma, NYBuilt 1975 · S/N 17266591 N13601Szuminski Gary F · Palm City, FLBuilt 1974 · S/N 17262873 N13602Dury Vernon E II · Hurst, ILBuilt 1974 · S/N 17262874 N13604Kadlec Ron · Roscoe, SDBuilt 1974 · S/N 17262876 N13605Bolinger Keith · Manheim, PABuilt 1974 · S/N 17262877 N13611Stitt Gordon C · Saint Germain, WIBuilt 1974 · S/N 17262883

Back to Cessna 172M