Skip to content

Registered aircraft · 413

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

N7788XBowling John D · Bryan, TXBuilt 1961 · S/N 17248288 N7791XCarson Roy K · Prescott Valley, AZBuilt 1961 · S/N 17248291 N7792XNorthern Light Aviation LLC · North Waterboro, MEBuilt 1961 · S/N 17248292 N7794XQuantum Edge Aviation Co · Boulder, COBuilt 1961 · S/N 17248294 N7795XMcclure Kyle · Elbert, COBuilt 1961 · S/N 17248295 N7796XParnello Nick · Rockford, ILBuilt 1961 · S/N 17248296 N7801XHuckins Randall A · Goddard, KSS/N 17248301 N7802XDykstra Wayne A · Pipestone, MNBuilt 1961 · S/N 17248302 N7807XFarwell Joseph W · Holmen, WIBuilt 1961 · S/N 17248307 N7810XCoats Benjamin F II · Ducktown, TNBuilt 1960 · S/N 17248310 N7811XMach 3 LLC · Enid, OKBuilt 1961 · S/N 17248311 N7814XOsterhouse Timothy D · Kalamazoo, MIBuilt 1961 · S/N 17248314 N7815XHearn Brian Franklin Trustee · Carrabelle, FLBuilt 1961 · S/N 17248315 N7820XMassiel Galvan Grijalva Frida Trustee · Tucson, AZBuilt 1961 · S/N 17248320 N7824XClampitt Kenton V · Eckert, COBuilt 1960 · S/N 17248324 N7827XBarrows Carl A · Lisle, NYBuilt 1961 · S/N 17248327 N7828XAero Smart LLC · Preston, IDBuilt 1961 · S/N 17248328 N7829XObservation Corp · Newark, CABuilt 1961 · S/N 17248329 N7831XChupka Kris W · Golden, COBuilt 1961 · S/N 17248331 N7833MFoote Lori A · Decherd, TNBuilt 1960 · S/N 17247978 N7836XOsage Aviation LLC · Yates Center, KSS/N 17248336 N7839XBedsole Jerry L · Elba, ALBuilt 1961 · S/N 17248339 N7840XShaw Christopher S · Porterville, CAFirst renewal noticeBuilt 1961 · S/N 48340 N7841XKleczkowski Aaron · Santa Rosa, CAS/N 17248341 N7843XEpidendio Peter W · Lakeport, CABuilt 1961 · S/N 17248343 N7844XFeather Farms Inc · Griffithville, ARBuilt 1961 · S/N 17248344 N7847XNix Charles W · San Jose, CABuilt 1961 · S/N 17248347 N7855XBensema Amber L · Winchester, CAS/N 17248355 N7856XBrown Daniel F · Belgrade, MTBuilt 1961 · S/N 17248356 N7859XGraves David E · Astoria, ORS/N 17248359 N7862XWorld Sky Academy Inc · Deland, FLS/N 17248362 N7864XDean John B · Chandler, AZBuilt 1961 · S/N 17248364 N7865XBrennan Nicholas · Foley, ALS/N 17248365 N7867XBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 17248367 N7868XReid Brian S · Merced, CAFirst renewal noticeS/N 17248368 N7874XPope Bradley L · Woodstock, GABuilt 1961 · S/N 17248374 N7875XMartin Tommy L · Vancouver, WABuilt 1961 · S/N 17248375 N7876XKotrla Claren J · Hilltop Lakes, TXBuilt 1961 · S/N 17248376 N7879XCopeland David R · Little Rock, ARBuilt 1961 · S/N 17248379 N7882XDefenbau James · Sierraville, CABuilt 1961 · S/N 17248382 N7883XRegistration Pending · Derby, KSRegistration pendingS/N 17248383 N7895XVerhalen John P Jr · Scottsville, TXBuilt 1961 · S/N 17248395 N7899XHines Jairus B · Lenoir City, TNBuilt 1961 · S/N 17248399 N7904XWishart Eric G · Reno, NVBuilt 1961 · S/N 17248404 N7906XNewton Ashlynne S · Yuma, COS/N 17248406 N7909XEisenhauer Lyle M · Sterling, NEBuilt 1961 · S/N 17248409 N7911XRice David L · Dickson, TNBuilt 1961 · S/N 17248411 N7912XWang Jinrao · Riverdale, GABuilt 1961 · S/N 17248412 N7916XMick Edward W · Harrisburg, ILBuilt 1961 · S/N 17248416 N7919XAirheads LLC · Lake City, MIBuilt 1961 · S/N 17248419

Back to Cessna 172B