Skip to content

Registered aircraft · 1,805

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

N5730AMunson Steven L · Martinsburg, WVBuilt 1956 · S/N 28330 N5734AEisenbrey Glen T · Greenbank, WABuilt 1956 · S/N 28334 N5739ADaystar Ltd · Ellsworth, KSS/N 28339 N5742ADirt Devil Aviation LLC · Bowdon Junction, GAS/N 28342 N5746AManier Byron K · Houston, MOBuilt 1956 · S/N 28346 N5748AGaines Matthew M · Plattsburg, MOBuilt 1956 · S/N 28348 N5749AScobey Robert P · Weiser, IDBuilt 1956 · S/N 28349 N5755ABlue Sky Flyers Inc · Joplin, MOBuilt 1956 · S/N 28355 N5756AKunz Isaac A · Texarkana, TXBuilt 1956 · S/N 28356 N5759AFlying K & Associates Inc · Hawthorne, FLBuilt 1956 · S/N 28359 N5764AMorrison Benjamin F III · Godley, TXBuilt 1956 · S/N 28364 N5766ASoma Holdings LLC · Wasilla, AKBuilt 1956 · S/N 28366 N5768AGowing Glyn Thomas · Longview, TXBuilt 1956 · S/N 28368 N5771AHunt Jack D · Wilmington, NCBuilt 1956 · S/N 28371 N5772ALawlor Stephen M · Saint Joseph, MOBuilt 1956 · S/N 28372 N5773AMelton James A · Mayflower, ARBuilt 1956 · S/N 28373 N5774ALoughney Michael L · Indialantic, FLBuilt 1956 · S/N 28374 N5775AWeber Francis W Jr · Le Sueur, MNBuilt 1956 · S/N 28375 N5783ABright Corner Charter LLC · Bozeman, MTBuilt 1956 · S/N 28383 N5784AAnderson Steve R · Dillon, COS/N 28384 N5786ABongiorni Robert W Jr · Burgettstown, PABuilt 1956 · S/N 28386 N5788AWeston Stetson J · Tremonton, UTBuilt 1956 · S/N 28388 N5790ASheen Mark Andrew · Snowflake, AZBuilt 1956 · S/N 28390 N5794APerkins Larry L · Wildomar, CAFirst renewal noticeBuilt 1956 · S/N 28394 N5797AEver Fast LLC · Kalispell, MTS/N 28397 N5798ABowman Ronald J · Bellefonte, PABuilt 1956 · S/N 28398 N5799AMiller Lavon S · Eureka, NVS/N 28399 N57MWFogal Brian K · Chambersburg, PABuilt 1957 · S/N 29688 N5800ACarson A Jane · Vance, ALBuilt 1956 · S/N 28400 N5800CFreixas Enrique · Torrance, CABuilt 1957 · S/N 36435 N5804ASandall Evan R · Bonsall, CABuilt 1956 · S/N 28404 N5805AVictory Aero Tech Inc · Camarillo, CABuilt 1956 · S/N 28405 N5811AHayes Gareth E · Durham, NCBuilt 1956 · S/N 28411 N5816AMitzelfeldt James W · Stanwood, WABuilt 1956 · S/N 28416 N5820ARivas Tito David · San Diego, CABuilt 1956 · S/N 28420 N5821ABaraga Matthew J · Texarkana, TXBuilt 1956 · S/N 28421 N5822ASteen Valerie · Lufkin, TXS/N 28422 N5825AHayes William A · Falls Of Rough, KYS/N 28425 N5828APerera Carl Anthony · Gilbert, AZBuilt 1956 · S/N 28428 N5829AVine Clayton A · Wolf Point, MTS/N 28429 N5830AChapman Erin A · Edmond, OKBuilt 1956 · S/N 28430 N5832ABurgess Kelly M · Dannebrog, NEBuilt 1956 · S/N 28432 N5833AJones Curtis DBA · Jacksonville, NCBuilt 1956 · S/N 28433 N5835ABoyd Edward L · Riverton, ILBuilt 1956 · S/N 28435 N5836AMallach Kenneth L · Gatesville, TXFirst renewal noticeBuilt 1956 · S/N 28436 N5837ACrawford Mike R · Flowery Branch, GABuilt 1956 · S/N 28437 N5841ASeipel Damian Y · Huntington Beach, CABuilt 1956 · S/N 28441 N5841GCrawford Trevor Nicolas · Potter Valley, CABuilt 1956 · S/N 28499 N5846AHalford Richard W · Eagle River, AKBuilt 1956 · S/N 28446 N5847ACochran Josh · New Orleans, LABuilt 1956 · S/N 28447

Back to Cessna 172