Skip to content

Registered aircraft · 3,572

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

N29028Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1974 · S/N 17264095 N29047State College Pilots Club · Philipsburg, PABuilt 1974 · S/N 17264096 N29056Land Of Lakes Aviation LLC · Eagle River, WIBuilt 1974 · S/N 17264097 N29107Wrong Brothers Aviation LLC · Brighton, MIBuilt 1974 · S/N 17264100 N29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeBuilt 1974 · S/N 17264103 N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104 N29168Galer Michael J Jr · Lockwood, MOBuilt 1974 · S/N 17264105 N29239Gibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264108 N29251Southeast Aviation Services Inc · Hattiesburg, MSBuilt 1974 · S/N 17264110 N29286Wawro Christopher · East Troy, WIBuilt 1974 · S/N 17264114 N292CAChoice Aviation LLC · Hamilton, MTBuilt 1976 · S/N 17266685 N293CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266259 N29552Montgomery Skyhawk LLC · Bethesda, MDBuilt 1974 · S/N 17264118 N29664Tyree William B · Arlington, TXBuilt 1974 · S/N 17264119 N29HLSchreiber Christopher · Foley, ALBuilt 1975 · S/N 17266262 N29MXPeterson Jim · Bedford, WYBuilt 1975 · S/N 17266309 N2HABrunner Robert L · Jefferson, ORBuilt 1975 · S/N 17265382 N2XCMiller Virgil J · Milton Freewater, ORS/N 17266833 N300LCRobinson Russell J · Bridgeport, TXBuilt 1973 · S/N 17261520 N3011FGordon Air Services Inc · Miami, FLBuilt 1974 · S/N 17263447 N30184Cp Aviation Inc · Santa Paula, CABuilt 1974 · S/N 17264125 N301JRTropitech Inc · San Juan, PRBuilt 1973 · S/N 17261555 N301NDPutzke Becky A · Fort Ripley, MNS/N 17261763 N30278Barron Joseph M · Des Moines, IABuilt 1975 · S/N 17264133 N30285Galena City School District · Galena, AKBuilt 1974 · S/N 17264135 N30370Fellow Ship Aviation LLC · Monticello, GABuilt 1974 · S/N 17264136 N303LKWestwind Aviation Inc · Bremerton, WABuilt 1973 · S/N 17262140 N30475Am Rhein Thomas R · Watsonville, CABuilt 1973 · S/N 17262791 N30514S&S Aircraft Inc · Bennington, VTBuilt 1974 · S/N 17264141 N30522Colvin Buster · Big Cabin, OKBuilt 1974 · S/N 17264142 N30579Dry Creek Services LLC · Lodi, OHBuilt 1974 · S/N 17264145 N305PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264131 N305XXDs Group LLC · Miami, FLBuilt 1975 · S/N 17265513 N30617Executive Flight Training & Services LLC · Sanford, NCBuilt 1974 · S/N 17264149 N30643Hurst Gordon · Waterford, PABuilt 1974 · S/N 17264150 N307BMBow Mac Aviation LLC · Spring Lake, MIBuilt 1973 · S/N 17262450 N307CREmpire Of Stars Commercial And Residential Real · Downey, CAS/N 17262385 N307GHollister Jet Center Inc · Hollister, CABuilt 1974 · S/N 17263007 N309MMDavenport James M II · Hollywood, FLBuilt 1975 · S/N 17265518 N30GSClausen Robert G · Argyle, MNBuilt 1973 · S/N 17261470 N312CLBroadseam Aviation LLC · Kodak E, TNS/N 17263599 N312TDAircom Nwa LLC · Siloam Springs, ARBuilt 1976 · S/N 17266129 N313BLDaggett Keith W · Rockport, MEBuilt 1976 · S/N 17267097 N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557 N315MTFly Mt Llp · Charlo, MTS/N 17267276 N316CAChoice Aviation LLC · Hamilton, MTS/N 17265960 N317ACChickenhawk Inc · Wilmington, MABuilt 1975 · S/N 17265537 N318PWN318pw LLC · New Canaan, CTBuilt 1973 · S/N 17262171 N319JPElon Aviation LLC · Burlington, NCBuilt 1973 · S/N 17262752 N31ACTango Thirty Aero Clube Inc · Mckinney, TXS/N 17261643

Back to Cessna 172M