Skip to content

Registered aircraft · 445

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

N5285VMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1980 · S/N 172RG0495 N5298VGeorgia Building Solutions LLC · Cleveland, GABuilt 1980 · S/N 172RG0501 N5305VAmerican Academy Of Aeronautics Inc · Stanford, CAS/N 172RG0504 N5306RSheldon Scott H · Cohasset, MABuilt 1979 · S/N 172RG0051 N5316RTraining Planes LLC · Tampa, FLBuilt 1979 · S/N 172RG0053 N5338VMassie Patrick J · Friendswood, TXBuilt 1980 · S/N 172RG0509 N5346VRegistered aircraftBuilt 1980 · S/N 172RG0510 N5348VKavon Clinreg LLC · Palm Beach Gardens, FLBuilt 1980 · S/N 172RG0511 N5354RCape May Aviation LLC · Cape May, NJS/N 172RG0056 N5369RArmbruster LLC · Amherst, OHBuilt 1979 · S/N 172RG0058 N5372VCooper'S Hawk Aviation LLC · Rochester, MIBuilt 1980 · S/N 172RG0516 N5377VShoemake Stephen Sidney · Pine Mountain, GABuilt 1980 · S/N 172RG0517 N5390VSpringfield Flying Service LLC · Columbia, CABuilt 1980 · S/N 172RG0518 N5393VPeterson Gary E · Bainbridge Island, WAS/N 172RG0519 N5403VL & R Consulting LLC · Las Vegas, NVBuilt 1980 · S/N 172RG0521 N5412VG & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0524 N5424VSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 172RG0528 N5443VTurk Aviation LLC · O Fallon, ILBuilt 1980 · S/N 172RG0533 N5493RFreedom Flight Center Inc · Hardy, NEBuilt 1979 · S/N 172RG0064 N5523RPlett John · Anaconda, MTBuilt 1979 · S/N 172RG0069 N5526RQualitair LLC Trustee · MichelstadtS/N 172RG0070 N5528RVroom Brian D · Tucson, AZS/N 172RG0071 N5533RThompson Aaron R · Louisville, KYS/N 172RG0072 N5537RBalady Nabih · Santa Clarita, CABuilt 1979 · S/N 172RG0073 N5546RGorn Joel · Lawrence, MABuilt 1979 · S/N 172RG0075 N5552VJust Plane Stuff Inc · Jackson, MSBuilt 1980 · S/N 172RG0570 N580SUMetro Aviation Inc · Shreveport, LABuilt 1981 · S/N 172RG0877 N590SProspect Ridge Aviaton Inc · Morganton, NCBuilt 1981 · S/N 172RG0818 N6083VScholz Francis M · Atchison, KSBuilt 1980 · S/N 172RG0571 N6090VRoberts Jon J · Parker, COBuilt 1980 · S/N 172RG0573 N6091VJames Jay C · Mesa, AZBuilt 1980 · S/N 172RG0574 N6092VAir Venture LLC · Au Gres, MIBuilt 1980 · S/N 172RG0575 N6102RAerospace Aviation Services Inc · Wilmington, DEBuilt 1979 · S/N 172RG0084 N6105VSchlesinger Henry R · Castalian Springs, TNBuilt 1980 · S/N 172RG0580 N610HPValor View Aviation LLC · Midland, TXBuilt 1981 · S/N 172RG0892 N6113RColorado Northwestern Community College · Rangely, COBuilt 1979 · S/N 172RG0086 N6113VLegacy Lsa LLC · Plainview, TXBuilt 1980 · S/N 172RG0581 N6121VPugmire Marsh C · Saint Charles, IDBuilt 1980 · S/N 172RG0582 N6127VSorbi Aviation Inc · El Cajon, CAS/N 172RG0583 N6132VDorsey Russell R · Phoenix, AZBuilt 1980 · S/N 172RG0584 N6135RStafford Michael J · Clovis, CABuilt 1979 · S/N 172RG0089 N6147RBloom James F · Clay City, KYS/N 172RG0094 N6149VFoode Frank J · Cordova, AKBuilt 1980 · S/N 172RG0587 N6150RChristy David L DBA · Meriden, KSBuilt 1979 · S/N 172RG0095 N6159RBagamaspad Alan M · Reseda, CABuilt 1979 · S/N 172RG0098 N6169RN999gk LLC · Nantucket, MAS/N 172RG0102 N616SFAmelia Reid Aviation LLC · San Jose, CABuilt 1980 · S/N 172RG0740 N6174RLaurel Highlands Aeronautical Academy · Latrobe, PAS/N 172RG0103 N6179RMcclinton Charles R · Cape Coral, FLBuilt 1979 · S/N 172RG0104 N6181RTrahan Gregory M · Rayne, LABuilt 1979 · S/N 172RG0106

Back to Cessna 172RG