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.

N8879BKatsahnias George T · Denton, TXBuilt 1958 · S/N 36579 N8880Causey Dale L · Albuquerque, NMBuilt 1956 · S/N 28459 N8883BMoe Jean A · Detroit Lakes, MNBuilt 1958 · S/N 36583 N8884BBrunson Aviation LLC · Little Elm, TXBuilt 1958 · S/N 36584 N8886BNeil John L Sr · Port Huron, MIBuilt 1958 · S/N 36586 N8889BDelise Nicholas M · Manteno, ILBuilt 1958 · S/N 36589 N8890BA-G-E Corp · Fort Pierre, SDBuilt 1958 · S/N 36590 N8896BFoster Michael W · Ellington, MOBuilt 1958 · S/N 36596 N8898BThompson Christopher L · Durango, COS/N 36598 N8899BBradberry Mason P · Wichita Falls, TXS/N 36599 N8900BMathews Denis W · Quanah, TXBuilt 1958 · S/N 36700 N8901BThompson Douglas P Trustee · Alton Bay, NHBuilt 1958 · S/N 36701 N8902BLeonard William L · Gettysburg, PABuilt 1958 · S/N 36702 N8905BGamble Dennis H · Cottonwood, ALBuilt 1958 · S/N 36705 N8907BRaven Aviation LLC · Lexington, KYBuilt 1958 · S/N 36707 N8908BAxmacher Mark A · Hillsboro, OHBuilt 1958 · S/N 36708 N8910BStone Tim · Siloam Springs, ARBuilt 1958 · S/N 36710 N8911BPeterson Clifford H · Old Town, MEBuilt 1958 · S/N 36711 N8916BSanborn George A Sr · Culver, ORBuilt 1958 · S/N 36716 N8917BTederman Terri Lynn · Auburn, WABuilt 1958 · S/N 36717 N8926BEmery Marilyn L · Randle, WABuilt 1958 · S/N 36626 N8927BSale Reported · Crystal, MNSale reportedS/N 36627 N8929BB&L Air Inc · Princeton, TXBuilt 1958 · S/N 36629 N8930BJohnson Kenneth J · Red Bluff, CABuilt 1958 · S/N 36630 N8934BPennington Clifford H · Mount Washington, KYBuilt 1958 · S/N 36634 N8936BPitman Marvin L · Harrah, OKS/N 36636 N8937BBradley James M · Fort White, FLBuilt 1958 · S/N 36637 N8940BFlamini Matthew D · Thompsons Station, TNBuilt 1958 · S/N 36640 N8941BBig R Of Greeley Inc · Greeley, COBuilt 1958 · S/N 36641 N8942BBishops Sky Cam LLC · Jonesburg, MOBuilt 1958 · S/N 36642 N8943BHarris David B III · Parlier, CAS/N 36643 N8946BLumberjack LLC · Flagstaff, AZBuilt 1958 · S/N 36646 N8947BKaczmarek Richard G · Sandersville, GAS/N 36647 N8950BPeppers Denise S · Centre, ALBuilt 1958 · S/N 36650 N8957BScott Larry R · Hobbs, NMS/N 36657 N8958BRaybourn David R · Salem, ORBuilt 1958 · S/N 36658 N8960BYocum Stuart J · Kingman, AZBuilt 1958 · S/N 36660 N8962BMorrison Glenda W · Lexington, NCFirst renewal noticeBuilt 1958 · S/N 36662 N8963BBeam Andrew · Benton Harbor, MIBuilt 1958 · S/N 36663 N8964BMuehl John M · Maryland, NYS/N 36664 N8966BSouthern Air Services Inc · Conway, ARBuilt 1958 · S/N 36666 N8969BHeiter Christopher S · Leesburg, INBuilt 1958 · S/N 36669 N8970BVecchioni Ronald N · Chantilly, VABuilt 1958 · S/N 36670 N8974BWaller Steven M · Sterling, COBuilt 1958 · S/N 36674 N8983BMcguire Zach T · Jasper, MOBuilt 1958 · S/N 36683 N8984BWhelchel Neil E · Joshua Tree, CABuilt 1958 · S/N 36684 N8987BHoover Rowdy L · Owasso, OKBuilt 1958 · S/N 36687 N8990BSortomme Jeffrey P · Sacramento, CABuilt 1958 · S/N 36690 N8995BSommerfeld David A · Assaria, KSBuilt 1958 · S/N 36695 N8996BGartrell Kirk W · Amarillo, TXBuilt 1958 · S/N 36697

Back to Cessna 172