Skip to content

Registered aircraft · 857

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

N27808St George Flight Academy LLC · St George, UTBuilt 1971 · S/N 17260023 N2805QA L Hollandsworth LLC · Columbia, MOBuilt 1971 · S/N 17259805 N2806QLawson Lance J · Sikeston, MOBuilt 1971 · S/N 17259806 N2807QReynolds David F · Port Orange, FLBuilt 1971 · S/N 17259807 N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810 N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812 N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813 N2819QAirborne LLC · Wilmington, DEBuilt 1971 · S/N 17259819 N2820QBush Steven B · Lago Vista, TXBuilt 1971 · S/N 17259820 N2824QAv8 LLC · Davenport, IAS/N 17259824 N2826QMcmillan Roger L · Camdenton, MOBuilt 1971 · S/N 17259826 N2828QJack Dixon · Haiku, HIBuilt 1971 · S/N 17259828 N2829QL & L Aviation LLC · Sidney, NEBuilt 1971 · S/N 17259829 N2830QRetro Modern Aviation LLC · Manitou Springs, COBuilt 1971 · S/N 17259830 N2834QHarford Flying Club Inc · Kingsville, MDBuilt 1971 · S/N 17259834 N2835QSan Fernando Aviation LLC · Van Nuys, CABuilt 1971 · S/N 17259835 N2837QChaffee Dean L · Weidman, MIBuilt 1971 · S/N 17259837 N2838QAdriatic Holdings LLC · Cheyenne, WYBuilt 1971 · S/N 17259838 N2841QWight John I · Anchorage, AKBuilt 1971 · S/N 17259841 N2842QLaning Roland · Monument, COBuilt 1971 · S/N 17259842 N2844QReigle Aviation · Palmyra, PABuilt 1971 · S/N 17259844 N2846QStafford Richard J · Bayport, NYBuilt 1971 · S/N 17259846 N2847QDobbelaere Craig M · Oakwood, OHBuilt 1972 · S/N 17259847 N2848QFirst Eclipse Ltd · Richmond, VABuilt 1971 · S/N 17259848 N2849QSilver Ranch Airpark Inc · Jaffrey, NHBuilt 1971 · S/N 17259849 N2852QMillard Randy W · Auburn, CABuilt 1971 · S/N 17259852 N2853QShelton Stefon E · Oakland, CABuilt 1971 · S/N 17259853 N2857QM3 Aviation Florida LLC · Fort Pierce, FLBuilt 1971 · S/N 17259857 N2858QKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259858 N2859QSullivan Mark F · Cocoa Beach, FLBuilt 1971 · S/N 17259859 N2860QLawton Metropolitan Area Airport Authority · Lawton, OKBuilt 1971 · S/N 17259860 N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861 N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863 N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864 N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865 N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866 N2868QRutherford Services Inc · Plains, PABuilt 1971 · S/N 17259868 N2869QDurnall Daniel J · Sonora, CABuilt 1971 · S/N 17259869 N2872QTriad Aviation Academy LLC · Greensboro, NCBuilt 1971 · S/N 17259872 N2873QCloud Dancer Aviation Inc · Deland, FLBuilt 1971 · S/N 17259873 N2875QLani Lea Sky Tours LLC · Honolulu, HIBuilt 1971 · S/N 17259875 N2878QFields Williams H · Greensboro, NCBuilt 1971 · S/N 17259878 N2879QBlue Side Aviation LLC · Tampa, FLBuilt 1971 · S/N 17259879 N2881QNeenah Aircraft Leasing LLC · Neenah, WIBuilt 1971 · S/N 17259881 N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885 N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886 N2888QChilds William C · Bridgeport, ALS/N 17259888 N2890QCarrick Christopher A · Castro Valley, CABuilt 1971 · S/N 17259890 N2894QFerkin Mark A · Caldwell, IDBuilt 1971 · S/N 17259894 N2895QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259895

Back to Cessna 172L