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.

N9399BSamoilenko Sergey V · Hillsborough, NCBuilt 1958 · S/N 55199 N9404BRutledge Dianna G · Winder, GABuilt 1958 · S/N 55204 N9416BIsler Norman P · Brockport, NYBuilt 1958 · S/N 55216 N9420BJones Jeremy R · Lampasas, TXS/N 55220 N9422BFallbrook Air Service · Fallbrook, CAS/N 55222 N9423BDrean Alelandre C · Ajo, AZS/N 55223 N9425BGloeckler Alex · Pearl City, ILBuilt 1958 · S/N 55225 N9430BFuture Flyers Of Connecticut LLC · Simsbury, CTBuilt 1958 · S/N 55230 N9434BNamtvedt Erik · Wasilla, AKS/N 55234 N9436BWhitsell Jesse T · Sterling, CTBuilt 1958 · S/N 55236 N9440BRamos Daniel J · Pueblo, COS/N 55240 N9441BSmith Mickey D · Tyler, TXBuilt 1958 · S/N 55241 N9444BWallitner Aviation Inc · Renton, WAS/N 55244 N9449BLeaders Bob O · Clear Lake, MNBuilt 1958 · S/N 55249 N9453BCain James W · Big Rapids, MIBuilt 1958 · S/N 55253 N9459BMiller Jason · Clifton, NJS/N 55259 N9460BEdwards Ag Service · Primghar, IABuilt 1958 · S/N 55260 N9462BPustell Robert J · West Ossipee, NHBuilt 1958 · S/N 55262 N9463BSanford Scott · Rancho Cucamonga, CABuilt 1958 · S/N 55263 N9465BBartlett Robert E · Cleveland, TXBuilt 1958 · S/N 55265 N9466BStoots David A · Fairbanks, AKBuilt 1958 · S/N 55484 N9468BHayward David E · Middlesboro, KYBuilt 1958 · S/N 55268 N9472BGrundy James W · West Greenwich, RIS/N 55272 N9473BMulholland Thomas C Trustee · Orange Cove, CABuilt 1958 · S/N 55273 N9476BHigher Calling LLC · Johnstown, COBuilt 1958 · S/N 55276 N9477BMilson Stuart A · Midlothian, TXBuilt 1958 · S/N 55277 N9480BAlexis Aviation LLC · Greenwell Springs, LABuilt 1958 · S/N 55280 N9481BPueppke Clinton · Ayr, NDBuilt 1958 · S/N 55281 N9485BLuggar Michael D · Leonard, MNFirst renewal noticeBuilt 1958 · S/N 55285 N9487BFord Christian G · Pasco, WAS/N 55287 N9491BGuess Jonathan M · Pineville, LABuilt 1958 · S/N 55291 N9492BPack Charles · Millington, TNBuilt 1958 · S/N 55292 N9493BRowe Chad A · Fairbanks, AKBuilt 1958 · S/N 55293 N9495BFry John W · Vinita, OKBuilt 1958 · S/N 55295 N9498BKluenker Charles H · Roseville, CABuilt 1958 · S/N 55298 N96167Westrum Durl Troy · Norwalk, IAS/N 55203 N985EAStich David · Casper, WYBuilt 1958 · S/N 55077

Back to Cessna 175