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.

N462VTHammer Donovan E · Tualatin, ORS/N 172RG0343 N4653VMouton Charles J · Gladewater, TXBuilt 1980 · S/N 172RG0347 N4656VWest Riverbend LLC · Washington, MOS/N 172RG0348 N4666VRegistered aircraftBuilt 1980 · S/N 172RG0356 N4670VHale Joshua R · Navarre, FLBuilt 1980 · S/N 172RG0360 N4686VRegistration Pending · Patterson, LARegistration pendingS/N 172RG0365 N4687VSharp Cutlass LLC · Iowa City, IABuilt 1980 · S/N 172RG0366 N46MPAnderson Howard E · Luray, VABuilt 1983 · S/N 172RG1144 N4709RG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0013 N4711VLiddy Alan A · Seabrook Island, SCS/N 172RG0368 N4714RAlford William J · Erie, MIBuilt 1979 · S/N 172RG0014 N4720RHotkeys Holding LLC · Silver Spring, MDBuilt 1979 · S/N 172RG0016 N4721RWaterdawg Express LLC · Pocatello, IDBuilt 1979 · S/N 172RG0017 N4723RSmolkin Alexander S · North Chesterfield, VABuilt 1979 · S/N 172RG0018 N472KPB2 West Corp · Winona, MNBuilt 1981 · S/N 172RG0922 N4732VGeneral Aviation Support Corp · Rosamond, CABuilt 1980 · S/N 172RG0371 N473KPDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1982 · S/N 172RG1132 N4746RZurawski Joseph · Ocala, FLBuilt 1979 · S/N 172RG0022 N474KPFaith Norman E Jr · El Dorado, ARBuilt 1981 · S/N 172RG0825 N474TBDr Daniel Brancheau Pllc · Fenton, MIBuilt 1980 · S/N 172RG0238 N4752RCondors Flight LLC · Orlando, FLS/N 172RG0023 N4772RKimball Michael G · Placerville, COBuilt 1979 · S/N 172RG0027 N4782RSchulert Peter A · Lebanon, TNBuilt 1979 · S/N 172RG0030 N4788VM Fujii Inc · Costa Mesa, CABuilt 1980 · S/N 172RG0378 N4791VAmerican Eagle Realestate & Financing Corp · Royal Palm Beach, FLBuilt 1980 · S/N 172RG0379 N4796VPittman Robert · Ocala, FLBuilt 1980 · S/N 172RG0381 N4800VRegistered aircraftBuilt 1980 · S/N 172RG0382 N4805VBudulas Peter Panagiotis · Laurel, MDBuilt 1980 · S/N 172RG0384 N4816VCollins Lisa A · Lake Dallas, TXBuilt 1980 · S/N 172RG0388 N4823VStratus Air LLC · New Orleans, LAFirst renewal noticeBuilt 1980 · S/N 172RG0391 N4852VR & R Aviation Services LLC · Darien, ILS/N 172RG0400 N4856VColombie Michael A · Anchorage, AKBuilt 1980 · S/N 172RG0401 N4857VNewsouth Aviation LLC · Auburn, ALBuilt 1980 · S/N 172RG0402 N485GRegistered aircraftBuilt 1980 · S/N 172RG0306 N4861VRegistered aircraftBuilt 1980 · S/N 172RG0403 N486MSInternational Air Services Inc Trustee · Carson City, NVS/N 172RG0369 N4871VBt Aero Precission Flight Accademy LLC · Oakdale, CABuilt 1980 · S/N 172RG0406 N4895VEbrite Richard P · Long Beach, MSBuilt 1980 · S/N 172RG0410 N4896VSouth Aero LLC · Albuquerque, NMBuilt 1980 · S/N 172RG0411 N4921VFrumkin Mark Steven · Pittsburgh, PABuilt 1980 · S/N 172RG0416 N4922VHhd Aviation LLC · Hamilton, OHBuilt 1973 · S/N 172RG0417 N4939VFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1980 · S/N 172RG0420 N4953VMccreery Aviation Co Inc · Mcallen, TXBuilt 1980 · S/N 172RG0423 N4956VRegistered aircraftBuilt 1980 · S/N 172RG0425 N4958VFrank John M Jr · Alexandria, VABuilt 1980 · S/N 172RG0427 N4959VCutlass Cruisers Inc · Howard Lake, MNBuilt 1980 · S/N 172RG0428 N4962VAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N 172RG0430 N4971VGorman John Scott · Homosassa, FLBuilt 1980 · S/N 172RG0436 N4975VMiller David M · Fort Worth, TXBuilt 1980 · S/N 172RG0440 N4976VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 172RG0441

Back to Cessna 172RG