Skip to content

Registered aircraft · 1,805

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

N8740BOltrogge Construction Inc · Absarokee, MTBuilt 1957 · S/N 36440 N8741BPhoenix Air Inc · Orland Park, ILBuilt 1957 · S/N 36441 N8742BTexas Wings LLC · San Antonio, TXBuilt 1957 · S/N 36442 N8746BHeffron Jacob L · Little Falls, MNBuilt 1957 · S/N 36446 N8748BOstby Larry · Froid, MTBuilt 1957 · S/N 36448 N8750BLawson Winston P · Hillsboro, OHS/N 36450 N8754BFoster Steven M · Pekin, ILS/N 36454 N8755BBurton Mark L · Lebanon, OHFirst renewal noticeBuilt 1957 · S/N 36455 N8760BManaged Aviation Inc · The Villages, FLBuilt 1957 · S/N 36460 N8763BMellen Roger B · Roseburg, ORBuilt 1957 · S/N 36463 N8775BGauger Cody · Edmond, OKBuilt 1957 · S/N 36475 N8777BBurks Danny E · Fordland, MOBuilt 1957 · S/N 36477 N8778BJohnson Timothy L · Berlin, WIBuilt 1958 · S/N 36478 N8779BMeyers Jess H · Las Vegas, NVBuilt 1957 · S/N 36479 N8780BHite Douglas T · Frisco, TXBuilt 1957 · S/N 36480 N8783BRosine Steven D · Troutville, VAS/N 36483 N8787BHedgers Thomas W · Lino Lakes, MNS/N 36487 N8791BCook Robert G · Rensselaer, NYBuilt 1957 · S/N 36491 N8795BE2 Technologies Inc · Grand Haven, MIBuilt 1957 · S/N 36495 N8796BTetrault Phil H · Chisago City, MNS/N 36496 N8799BUssrey Charles W · Wellston, OKBuilt 1957 · S/N 36499 N8801BWelch Thomas R · Modesto, CAS/N 36501 N8803BEisert Stephan William · Mint Hill, NCBuilt 1957 · S/N 36503 N8807BLee Kendall Nathan · Madras, ORS/N 36507 N8809BEagles Wings Inc · San Angelo, TXBuilt 1957 · S/N 36509 N8811BMatty Elizabeth · Tucson, AZBuilt 1957 · S/N 36511 N8814BEvans Roy L · Winnemucca, NVBuilt 1957 · S/N 36514 N8815BWiser Kurtis · Kennewick, WAS/N 36515 N8818BFairfield Eugene D · Wiscasset, MEBuilt 1957 · S/N 36518 N8822BDalton James B · Wells, NVBuilt 1957 · S/N 36522 N8824BHickman Jack · Albuquerque, NMBuilt 1957 · S/N 36524 N8828BThomas Abigail M · Lyman, NHBuilt 1957 · S/N 36528 N8832BSale Reported · Miami Beach, FLSale reported, pending cancellationBuilt 1958 · S/N 36532 N8838BMason City Enterprises LLC · Mason City, NES/N 36538 N8839BRiberio Trucking LLC · Stratford, CTBuilt 1957 · S/N 36539 N8841BErwin Brandon · Jacksboro, TXS/N 36541 N8843BBaker Ralph · Lake Geneva, FLS/N 36543 N8845BB1rd Flying LLC · Hotchkiss, COBuilt 1957 · S/N 36545 N8847BSeymour John R · Findlay, OHS/N 36547 N8852BShuck Herbert K · Meadow Bridge, WVBuilt 1957 · S/N 36552 N8857BSafe Skies Aviation LLC · Middletown, OHBuilt 1957 · S/N 36557 N8858BPiper Joseph C II · Walsenburg, COBuilt 1958 · S/N 36558 N8859BRandolph James C · Ridgecrest, CABuilt 1958 · S/N 36559 N8860BStraight Tail Flyers LLC · Peoria, ILBuilt 1958 · S/N 36560 N8863BMollere Michael E · Marion, TXS/N 36563 N8865BRegistration Pending · Wentzville, MORegistration pendingBuilt 1958 · S/N 36565 N8867BCowan Rena E · Pleasant Hill, ORBuilt 1958 · S/N 36567 N8871BSing Clifford J Trustee · Idaho Falls, IDBuilt 1958 · S/N 36571 N8873BPathfinder Aerospace LLC · Raeford, NCBuilt 1958 · S/N 36573 N8876BBeryl Aviation LLC · Omaha, NEBuilt 1958 · S/N 36576

Back to Cessna 172