Skip to content

Registered aircraft · 3,138

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

N2431ESpartan College Of Aeronautics And Technology · Broomfield, COBuilt 1978 · S/N 17271280 N2442EExecutive Flyers Inc · Sacramento, CABuilt 1978 · S/N 17271285 N2448EPwc Engine Air Inc · Manorville, NYS/N 17271288 N244FRSmith Larry · Ulysses, KSBuilt 1978 · S/N 17270490 N245FRChupito Sabrocito LLC · Paso Robles, CABuilt 1977 · S/N 17269686 N2462EFive Six Zero One LLC · Orange, CABuilt 1978 · S/N 17271291 N2465ELeal Felipe · Missouri City, TXBuilt 1978 · S/N 17271292 N2466EMarkham Dean F Jr · Greenville, NCBuilt 1978 · S/N 17271293 N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294 N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023 N2474EBas Part Sales LLC · Greeley, COS/N 17271297 N248ERUnverferth Gregory T · Fort Jennings, OHS/N 17271977 N2495Lynch Sean L · Brighton, ILBuilt 1978 · S/N 17270282 N2497EBenham Aviation LLC · Enid, OKBuilt 1978 · S/N 17271303 N249NYWoldt Wayne E · Raymond, NEBuilt 1978 · S/N 17271032 N24CVPacific Air Flight School LLC · Long Beach, CABuilt 1977 · S/N 17270186 N252ERBeaurayne Holdings LLC · Prairieville, LABuilt 1978 · S/N 17271635 N252RAReynolds Darryl G · Wills Point, TXBuilt 1977 · S/N 17269911 N252SBRoberts Christopher E · Anchorage, AKS/N 17270764 N255KRAvra Valley Flyers LLC · Gilbert, AZS/N 172-69860 N256MWLease Air LLC · Moab, UTBuilt 1977 · S/N 17269958 N257FK257fk LLC · Marathon, FLBuilt 1977 · S/N 17269126 N258ERLewis Carlos Brandon · Indian Mound, TNBuilt 1978 · S/N 17270891 N258MAJ Linn Aviation Inc · Quinlan, TXS/N 17269926 N258RAReynolds Darryl G · Wills Point, TXBuilt 1978 · S/N 17270533 N25ESGeneral Aviation Support Corp · Rosamond, CABuilt 1977 · S/N 17269082 N25SKH & H Aviation Enteprises LLC · Fairfield, OHBuilt 1979 · S/N 17273152 N262MGordon Bruce · Marstons Mills, MABuilt 1976 · S/N 17268356 N2630MMock Air LLC · Marion, INBuilt 1979 · S/N 17271166 N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716 N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081 N269BJN2893e LLC · Reno, NVS/N 17270380 N269NEOro LLC · Tilden, NES/N 17272505 N26CWBarzelatto Brett · Thornton, COS/N 17272496 N26FPTate Zachary W · Cypress, TXBuilt 1978 · S/N 17271318 N2720EAmerican Patrols Inc · Midland, TXBuilt 1978 · S/N 17271305 N2723EMarshals Technology LLC · Martinez, GABuilt 1978 · S/N 17271306 N272DKKroutil David W · Hilmar, CABuilt 1978 · S/N 17271857 N272TLSanders Flight Training Center · Jasper, ALS/N 17270719 N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803 N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677 N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309 N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643 N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018 N2744JOvation Cwa LLC · Prairie Du Sac, WIBuilt 1979 · S/N 17273644 N2749EB2fh Ltd · Allentown, NJBuilt 1978 · S/N 17271314 N2754EGulf Coast Helicopters Inc · Pearland, TXBuilt 1978 · S/N 17271315 N275GTPs N275gt LLC · Green Bay, WIBuilt 1978 · S/N 17271631 N2774JPerez Guillermo · Castaic, CABuilt 1979 · S/N 17273649 N2775EFaulkner Harry E Jr · Bethel, AKBuilt 1978 · S/N 17271316

Back to Cessna 172N