Skip to content

Registered aircraft · 781

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

N1784FTompkins Wyatt · Pearland, TXBuilt 1966 · S/N 17255179 N1785FSale Reported · Farragut, TNSale reportedBuilt 1966 · S/N 17255180 N1787FSchroder Robert D · Buckeye, AZBuilt 1966 · S/N 17255182 N1790FTaylor Henry F · Urbana, OHBuilt 1966 · S/N 17255185 N189WMatta Figueroa Eduardo · Chapman, KSBuilt 1967 · S/N 17255907 N18HRJ & R Aviation LLC · Hamilton, OHBuilt 1967 · S/N 17256269 N19HRJernigan Michael G · Toledo, ORBuilt 1966 · S/N 17255607 N200ZKInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N 17255678 N2169YRudy Jonathan E · New Cumberland, PABuilt 1967 · S/N 17256395 N2401LDelta Ridge Farms LLC · Oak Grove, LAS/N 17255601 N2402LLehman Michael N · Lansing, KSBuilt 1966 · S/N 17255602 N2403LSeibert Richard L · Gibsonia, PABuilt 1966 · S/N 17255603 N2404LStalder David L · Amanda, OHBuilt 1966 · S/N 17255604 N2410LSammons Mitchell · Belgrade, MEBuilt 1966 · S/N 17255610 N2411LEfinger John M · Cresson, TXS/N 17255611 N2415L98x LLC · Caddo Mills, TXS/N 17255615 N2416LBeck Roger M Trustee · Goode, VABuilt 1966 · S/N 17255616 N2417LBox Aviation Inc · Montgomery, ALBuilt 1966 · S/N 17255617 N2418LF Sharp Aviation LLC · New Baltimore, MIBuilt 1966 · S/N 17255618 N2419L2419l LLC · Jackson, MIBuilt 1966 · S/N 17255619 N241NYColonial Aviation LLC · N Prince George, VAS/N 17256479 N2421LPerdue Dustin W · Mooresville, INBuilt 1966 · S/N 17255621 N2422LTravis Equipment LLC · Bee Cave, TXBuilt 1966 · S/N 17255622 N2423LBig Hook Wilderness Camps LLC · Snowmass Village, COBuilt 1966 · S/N 17255623 N2424LRoberts Steven R · Palo Verde, AZBuilt 1966 · S/N 17255624 N2425LZappia Jonathan L · Yucaipa, CABuilt 1967 · S/N 17255625 N2426L588 Delta LLC · Seminole, OKBuilt 1966 · S/N 17255626 N2427LT&T Aviators LLC · Buford, GAS/N 17255627 N2429LCook Shawn R · Middlebury, VTBuilt 1966 · S/N 17255629 N2430LTaylor Kerry J · Childress, TXBuilt 1966 · S/N 17255630 N2431LMarsh John E · Washington, DCS/N 17255631 N2434LWeston Torey C · Unionville, MOBuilt 1966 · S/N 17255634 N2435LAero Science International LLC · Augusta, GABuilt 1966 · S/N 17255635 N2439LBetts William B · Big Lake, AKS/N 17255639 N2440LEads Kevin C · Arley, ALBuilt 1966 · S/N 17255640 N2442LPratt Mark R · La Grande, ORBuilt 1966 · S/N 17255642 N2443LOdlozil Henry W · Ennis, TXBuilt 1966 · S/N 17255643 N2449LSteier Tim · Salome, AZBuilt 1966 · S/N 17255649 N2450LRobinson Brandon J · Winona Lake, INS/N 17255650 N2451LSky K Inc · Wilmington, DES/N 17255651 N2454LFulbright Steven R · Prineville, ORBuilt 1966 · S/N 17255654 N2458LBowman Joseph F · Flora, MSBuilt 1966 · S/N 17255658 N2459LMedia Stew LLC · Carson City, NVBuilt 1966 · S/N 17255659 N2462LSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 17255662 N2467LPatton Michael D · Tygh Valley, ORBuilt 1966 · S/N 17255667 N2468LCavender Kevin S · Tucson, AZBuilt 1966 · S/N 17255668 N2470LSmith Joseph · Sycamore, ILBuilt 1966 · S/N 17255670 N2479LMoore Joseph A · Kingwood, WVBuilt 1966 · S/N 17255679 N2480LStephens Ryan J · Dallas, PABuilt 1966 · S/N 17255680 N2481LGhaemmaghami Ommid · Mckinney, TXBuilt 1966 · S/N 17255681

Back to Cessna 172H