Skip to content

Registered aircraft · 537

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

N7390MBechtel Jerold L · Snover, MIBuilt 1958 · S/N 55690 N7391MAnderson Richard A · Sycamore, ILBuilt 1958 · S/N 55691 N7392MSantana Marcos · Concord, NCS/N 55692 N7393MJ S Imperio Construction And Real Estate Svc/S LLC · Laredo, TXBuilt 1958 · S/N 55693 N7397MBuck Mark E · St Maries, IDBuilt 1958 · S/N 55697 N7400M7400m Air Inc · Auburn, ALBuilt 1958 · S/N 55700 N7404MHrevans Cessna 175 LLC · Fairbanks, AKBuilt 1958 · S/N 55704 N7414MFrenzel Carl O · Midlothian, TXBuilt 1959 · S/N 55714 N7419MStepp William F III · Williamsport, PABuilt 1959 · S/N 55719 N7420MRegistration Pending · Fort Recovery, OHRegistration pendingBuilt 1959 · S/N 55720 N7421MMojzisik Allan W · Westerville, OHBuilt 1959 · S/N 55721 N7422MFadling Daniel L · Port Orange, FLBuilt 1959 · S/N 55722 N7426MPhipps David B · Scottsdale, AZBuilt 1959 · S/N 55726 N7431MWestern Pacific Systems Inc · Anchorage, AKS/N 55731 N7439MBrooks Randall L · Queen Creek, AZBuilt 1958 · S/N 55739 N7440MAustin Kevin · Roseville, CABuilt 1959 · S/N 55740 N7443MVaccari Kevin N · Walnut Ridge, ARBuilt 1959 · S/N 55743 N7444MMitchell Lester L · Okmulgee, OKBuilt 1958 · S/N 55744 N7446MHobson George A · Fairbanks, AKBuilt 1958 · S/N 55746 N7448MCadwell David Earl · Windsor, COBuilt 1959 · S/N 55748 N7450MJones Jeremy · Lampasas, TXS/N 55750 N7453MHauser Casey L · Springfield, ORBuilt 1959 · S/N 55753 N7454MSteier Tim A · Salome, AZBuilt 1959 · S/N 55754 N7457MThigpen Jacob T · Adkins, TXBuilt 1959 · S/N 55757 N7458MMcgowin Barry · Sylacauga, ALBuilt 1958 · S/N 55758 N7459MReel Chad A · Wasilla, AKS/N 55759 N7462MRegistered aircraftBuilt 1959 · S/N 55762 N7463MRothgeb Michael A · Ketchum, IDS/N 55763 N7464MCleveland William E · Perris, CAS/N 55764 N7465MSmith Justin Sean · Vancouver, WAS/N 55765 N7469MWolter Kenneth W · Wasilla, AKS/N 55769 N7470MPierce Steven P · Towanda, KSS/N 55770 N7475MRedmond Walter J · Austin, TXBuilt 1959 · S/N 55775 N7478MMayle Brian · West Granby, CTBuilt 1958 · S/N 55778 N7482MSchwab Mark C · Kimball, MIBuilt 1959 · S/N 55782 N7484MMesiar David C · Anchorage, AKBuilt 1959 · S/N 55784 N7485MLyons Adrian K · Torrance, CABuilt 1959 · S/N 55785 N7486MYaeger John F · Au Gres, MIBuilt 1959 · S/N 55786 N7487MMaple Lake Flyers Corp · Maple Lake, MNBuilt 1959 · S/N 55787 N7488MFegert Jeff · Las Vegas, NVBuilt 1959 · S/N 55788 N7489MMerinar John R Jr · Bridgeport, WVBuilt 1959 · S/N 55789 N7495MPlumley David E · Waxhaw, NCBuilt 1959 · S/N 55795 N7496MMcmurray Patrick T · Brush Prairie, WABuilt 1959 · S/N 55796 N7500MRoat Todd J · Rio, WIS/N 55800 N7501MAngus Glen R · Fernley, NVBuilt 1959 · S/N 55801 N7503MJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1959 · S/N 55803 N7509MFerry Douglas W · Santee, CABuilt 1959 · S/N 55809 N7511MDacus Jon Gremard · Jonesboro, ARS/N 55811 N7512MDewolfe Cheyne Z · Cave Creek, AZBuilt 1959 · S/N 55812 N7514MBergner Nicholas K · Avon, MNBuilt 1959 · S/N 55814

Back to Cessna 175