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.

N3892QKcn Aero Club Inc · Overland Park, KSS/N 17259992 N3893QSisung Ty J · Roxie, MSBuilt 1971 · S/N 17259993 N3896QNishna Valley Flying Club · Red Oak, IABuilt 1971 · S/N 17259996 N3898QJaynes Grayson V Sr · Burnet, TXBuilt 1971 · S/N 17259998 N3899QFlight Inc · Gastonia, NCBuilt 1971 · S/N 17259999 N389CLCanaan Land Church Inc · Autaugaville, ALBuilt 1972 · S/N 17260700 N3904QKern Bruce A · Collinsville, OKBuilt 1971 · S/N 17260004 N3905QH&H Cloudbase Aviation LLC · Carlsbad, CAS/N 17260005 N3908QShamrock Flying Service LLC · Denver, COBuilt 1971 · S/N 17260008 N3909QAdventure Seaplanes LLC · Tower, MNBuilt 1971 · S/N 17260009 N3911QTraining Planes LLC · Tampa, FLBuilt 1971 · S/N 17260011 N3914QAmerican Patrol Inc · Midland, TXBuilt 1971 · S/N 17260014 N3918QAviation Academy LLC · Wichita, KSBuilt 1971 · S/N 17260018 N3919QMinot Aero Center · Minot, NDBuilt 1971 · S/N 17260019 N3921QRawareo LLC · Warsaw, MOS/N 17260021 N3924QGarcia Theodore · Fullerton, CABuilt 1971 · S/N 17260024 N3925QFerrin Aviation LLC · Rome, GAFirst renewal noticeBuilt 1971 · S/N 17260025 N3926QLeaseair LLC · Wilmington, DEBuilt 1971 · S/N 17260026 N3927QHyatt Eric D · Bainbridge, GABuilt 1971 · S/N 17260027 N3929QMonk Steven M · Lake Tomahawk, WIBuilt 1971 · S/N 17260029 N3932QZimmer Jed Michael · Quincy, WAS/N 17260032 N3934QChase William R Jr · Enfield, NHBuilt 1971 · S/N 17260034 N3935QBeaufort Flight Training LLC · Beaufort, SCBuilt 1971 · S/N 17260035 N3938QGreen Carl P · Columbia, MSBuilt 1971 · S/N 17260038 N3940QN3940q LLC · Newnan, GABuilt 1971 · S/N 17260040 N3942QSullivan Donald Edward II · Edwards, ILBuilt 1971 · S/N 17260042 N3944QFeauto Aviation Inc · Saint Cloud, FLBuilt 1971 · S/N 17260044 N3948QCitabria Inc · Auburn, CABuilt 1971 · S/N 17260048 N3949QTuschen James E · Rockford, ILBuilt 1971 · S/N 17260049 N3950QDieter Jason W · Midlothian, VAS/N 17260050 N3951QGarcia Larry M · Garden Valley, CABuilt 1971 · S/N 17260051 N3952QLloyds 172 LLC · Moore, OKS/N 17260052 N3957QRwm Aviation LLC · Kalispell, MTBuilt 1971 · S/N 17260057 N3958QFisher Gregory S · Franklin, WIBuilt 1971 · S/N 17260058 N3960QLastochka LLC · Kalispell, MTBuilt 1971 · S/N 17260060 N3962QKalstrom William M · Ekalaka, MTBuilt 1971 · S/N 17260062 N3967QPeterson Dennis E · Cambridge, MNBuilt 1971 · S/N 17260067 N3970QPetree James D · Asotin, WABuilt 1971 · S/N 17260070 N3972QStiles Thomas · Mechanicsville, VABuilt 1971 · S/N 17260072 N3973QIdg Elsa LLC · Ann Arbor, MIBuilt 1971 · S/N 17260073 N3975QBrachtenbach Eric L · Hill City, KSS/N 17260075 N3977QLabanoski Mark B · Hornell, NYS/N 17260077 N3978QDv Aircraft Leasing · Green Bay, WIBuilt 1971 · S/N 17260078 N3979QCarey International Aviation Services LLC · Rockville Centre, NYBuilt 1971 · S/N 17260079 N3980QLanning 1 Aviation LLC · Amarillo, TXBuilt 1971 · S/N 17260080 N3982QSouther Field Aviation Inc · Americus, GABuilt 1971 · S/N 17260082 N3984QYarrington David W · Magnolia, DEBuilt 1971 · S/N 17260084 N3985QArnold Ralph F · Golden Valley, AZBuilt 1971 · S/N 17260085 N3986QMfv-N5498q Owners Association Inc · New Church, VABuilt 1971 · S/N 17260086 N3989QDms Leasing Co LLC · Las Vegas, NVBuilt 1971 · S/N 17260089

Back to Cessna 172L