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.

N7952BEmaw Properties LLC · Ketchum, OKBuilt 1957 · S/N 29752 N7953BSavener Eric D · Kingsland, TXBuilt 1957 · S/N 29753 N7955BCochrane Geoffrey G · Seville, OHBuilt 1957 · S/N 29755 N7958BThrustline Aviation LLC · Happy Valley, ORS/N 29758 N7959BLaminack Dale Wayne · Ralls, TXS/N 29759 N7960BHolte Martin W · Burnsville, MNS/N 29760 N7961BGmitter Joseph J · Forest Lake, MNBuilt 1957 · S/N 29761 N7962BHall Jason J · Moses Lake, WABuilt 1957 · S/N 29762 N7963BPerkins C Trent Blaise · Wonder Lake, ILBuilt 1957 · S/N 29763 N7966BBrashar Kevin · Anchorage, AKS/N 29766 N7967BScholz Alan A · Rosamond, CABuilt 1957 · S/N 29767 N7968BWaltz Patrick T · Delanson, NYBuilt 1957 · S/N 29768 N7969BConnolly Patrick J · Skaneateles, NYBuilt 1957 · S/N 29769 N7971BKimberling David L · Lincoln City, ORBuilt 1957 · S/N 29771 N7974BBraymer Jay K · Boerne, TXBuilt 1957 · S/N 29774 N7980BMikesell Luke A · Fairland, OKBuilt 1957 · S/N 29780 N7982BUlmer Brian K · Huachuca City, AZBuilt 1957 · S/N 29782 N7984BYoung Kenneth R · Waco, TXBuilt 1957 · S/N 29784 N7991BLowe Gayle C · Sacramento, KYBuilt 1957 · S/N 29791 N7993BAlmy David W · Riverside, CABuilt 1957 · S/N 29793 N7995BOtey Robert J · Goldendale, WABuilt 1957 · S/N 29795 N7996BG & R Flying Ltd · Chippewa Falls, WIBuilt 1957 · S/N 29796 N79FFamuliner James N · Carrollton, MOBuilt 1956 · S/N 29362 N8000BRoberts David C · Sidney, IABuilt 1957 · S/N 29800 N8001BRobinson Stephen A · London, KYBuilt 1957 · S/N 29801 N8003BLeopardi David E · Salt Lake City, UTBuilt 1957 · S/N 29803 N8008BNeill James H · Keller, TXBuilt 1957 · S/N 29808 N8009BTaber Floyd K · Osceola, IABuilt 1957 · S/N 29809 N8014BHeinrich George F Jr · Hastings, MNBuilt 1957 · S/N 29814 N8019BColonial Air Inc · New Bedford, MAS/N 29819 N8024BHatchie River Aviation LLC · Kalispell, MTS/N 29824 N8028BChandler Francis R · Anniston, ALBuilt 1957 · S/N 29828 N8030BPauly Douglas A · Hooksett, NHS/N 29830 N8034BChapin Lyle E · Luverne, MNBuilt 1957 · S/N 29834 N8036BTeets Casey D · Inverness, ILBuilt 1957 · S/N 29836 N8037BExecutive 21 LLC · Noblesville, INBuilt 1957 · S/N 29837 N8044BAshley Ken E · Maiden, NCBuilt 1957 · S/N 29844 N8046BAnderson Charles D · Fairbanks, AKBuilt 1957 · S/N 29846 N8047BGuidry Janice C · Mechanicsville, VABuilt 1957 · S/N 29847 N8048BHohman Brent A · Larchwood, IAS/N 29848 N8055BBraginetz Nathan Edward · Crozet, VABuilt 1957 · S/N 29855 N8058BBreisch Frederick A Jr · Findlay, OHBuilt 1957 · S/N 29858 N8061BUrioste Zachary Ty Fred · Fort Collins, COBuilt 1957 · S/N 29861 N8062BPalmer Felix E Jr · Murphy, NCBuilt 1957 · S/N 29862 N8064BCarrison Harold F · Pleasanton, CABuilt 1957 · S/N 29864 N8067BReynolds Ronnie · White Hall, ARBuilt 1957 · S/N 29867 N8069BFailmezger Robert A · Fulton, NYBuilt 1957 · S/N 29869 N8070BFlybravo LLC · Jasper, TXBuilt 1957 · S/N 29870 N8073BSachs James B · Rochester, NYBuilt 1957 · S/N 29873 N8074BGraziano Thomas K · Benson, AZBuilt 1957 · S/N 29874

Back to Cessna 172