Skip to content

Registered aircraft · 471

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

N111MFField Monica · Los Angeles, CABuilt 1963 · S/N 17250162 N123ACAerocareers Nfp · Columbia, ILBuilt 1962 · S/N 17249624 N1483VRankin Kevin · Maryville, MOS/N 17250241 N158AERobinson Bruce A · Salinas, CABuilt 1962 · S/N 17249943 N159AEGalbari Geno · Wales, WIS/N 17249954 N163MCCriddle Michael J · Baker, FLBuilt 1963 · S/N 17250149 N168MSDahlen S Timothy Jr · Westhampton, NYBuilt 1963 · S/N 17250564 N172VYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1963 · S/N 17250568 N2045YAir Dakota Flite Inc · Hettinger, NDBuilt 1962 · S/N 17249545 N2047YMohr Jacob Karl · Van Wert, OHBuilt 1962 · S/N 17249547 N2048YIron Horse Aviation LLC · Omak, WAS/N 17249548 N2051YMomba LLC · New Braunfels, TXBuilt 1962 · S/N 17249551 N2054YPetersen Paul R · Eldridge, IABuilt 1962 · S/N 17249554 N2057YCable Land Co · Upland, CABuilt 1962 · S/N 17249557 N2059YOlson Michael J · Kapaa, HIBuilt 1962 · S/N 17249559 N2061YBronzestar LLC · Butler, TNBuilt 1962 · S/N 17249561 N2064YRocheleau Adam A · Anchorage, AKBuilt 1962 · S/N 17249564 N2067YShankle Christopher · Orlando, FLBuilt 1962 · S/N 17249567 N2068YFurchtenicht Corey L · Sarona, WIBuilt 1962 · S/N 17249568 N2074YLloyd Allan · Otter, MTBuilt 1962 · S/N 17249574 N2075YCampbell Joseph M · Jay Em, WYBuilt 1962 · S/N 17249575 N2076YOsteen Richmond S · Hendersonville, NCBuilt 1962 · S/N 17249576 N2078YBell Jason S · Coos Bay, ORBuilt 1962 · S/N 17249578 N2083YJackson David W · Prescott Valley, AZBuilt 1962 · S/N 17249583 N2084YRegistration Pending · Monroe, MIRegistration pendingBuilt 1962 · S/N 17249584 N2087YEllsworth Matthew R · Fairbanks, AKBuilt 1963 · S/N 17249587 N2088YHowell Rebecca Elizabeth · Elgin, TXBuilt 1962 · S/N 17249588 N2089YSooter Craig A · Sedgwick, KSBuilt 1962 · S/N 17249589 N2091YCut And Snip Flyers LLC · South Weber, UTBuilt 1962 · S/N 17249591 N2092YNiver Michael A · Plymouth, WIBuilt 1962 · S/N 17249592 N2093YSale Reported · Agar, SDSale reportedBuilt 1962 · S/N 17249593 N2094YHill Karl A · Visalia, CABuilt 1963 · S/N 17249594 N2095YJurca John · Punta Gorda, FLBuilt 1962 · S/N 17249595 N2097YWulff Jonathan P · Eaton Rapids, MIBuilt 1962 · S/N 17249597 N2098YLevel Altitude LLC · Seward, NEBuilt 1962 · S/N 17249598 N2105YLulays Aviation LLC · Salem, ORBuilt 1962 · S/N 17249605 N2107YOsborne Daniel M · Vero Beach, FLS/N 17249607 N2108YNorthwest Wings LLC · Hillsboro, ORBuilt 1962 · S/N 17249608 N2109YSnyder Chris · Olean, NYBuilt 1963 · S/N 17249609 N21103Mulvany Stephen L · Waxahachie, TXBuilt 1963 · S/N 17250301 N2111YKoepplinger Dawn M · Chesaning, MIBuilt 1962 · S/N 17249611 N2112YColorado Flight Center Inc · Grand Junction, COBuilt 1962 · S/N 17249612 N2115YDavis Rodney E · Nanty Glo, PABuilt 1962 · S/N 17249615 N2118YS&G Enterprise Inc · Owensville, INBuilt 1962 · S/N 17249618 N2120YSchwier Joyce M · Benton City, WAS/N 17249620 N2121YMclanahan John P · Culpeper, VABuilt 1963 · S/N 17249621 N2125YPalmer Ronald Everett Trustee · Sonoma, CABuilt 1962 · S/N 17249625 N2129YEdwards Air LLC · Raleigh, NCBuilt 1962 · S/N 17249629 N2133YBullock John E Jr · Birdseye, INBuilt 1962 · S/N 17249633 N2134YHi Line Flying Club Inc · Seattle, WABuilt 1962 · S/N 17249634

Back to Cessna 172D