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.

N5849AAllison Michael L · Lubbock, TXBuilt 1956 · S/N 28449 N5853ADanz Frederick C · Mattawa, WABuilt 1956 · S/N 28453 N5857ABrandt Jeff D · Ankeny, IABuilt 1956 · S/N 28457 N5858AMadey Benjamin · Ghent, NYBuilt 1956 · S/N 28458 N5860AMrd Aero LLC · Manheim, PAS/N 28460 N5862ASanders Mark R · Towner, COBuilt 1956 · S/N 28462 N5863ADabney Richard W · Tanner, ALBuilt 1956 · S/N 28463 N5864AS Aviation LLC · Wisconsin Dells, WIBuilt 1956 · S/N 28464 N5866AChipman Jeffrey M · Rising Sun, INS/N 28466 N5867AUrciuoli Salvatore · Holbrook, NYBuilt 1956 · S/N 28467 N5869AHurt Wally · Amboy, WABuilt 1956 · S/N 28469 N5870AGlenn Chester L · Hugo, OKBuilt 1956 · S/N 28470 N5873AWilemon Stephen L · Tulsa, OKBuilt 1956 · S/N 28473 N5874AShaha Zachary D · Menomonie, WIBuilt 1956 · S/N 28474 N5875ARoberts Dallon W · Kamiah, IDS/N 28475 N5876AThomas Christopher D · Santa Monica, CABuilt 1956 · S/N 28476 N5877AMangham Aviation LLC · Mullin, TXBuilt 1956 · S/N 28477 N5884ADe Witt Duane A · Colleyville, TXBuilt 1956 · S/N 28484 N5888ADahlberg James C · Ogilvie, MNS/N 28488 N5890AMartin Jason L · Fort Worth, TXBuilt 1956 · S/N 28490 N5895ADuncan Russell A · Glen Burnie, MDBuilt 1956 · S/N 28495 N5896AFox Black Enterprises Inc · Kilmarnock, VABuilt 1956 · S/N 28496 N5900AOlsen Porteous E · Houston, MNBuilt 1956 · S/N 28500 N5901ACoulson Michael D · Zanesville, OHBuilt 1956 · S/N 28501 N5902ASmith Kenneth W · Bedford, INBuilt 1956 · S/N 28502 N5903AHunt Kenneth · Humble, TXBuilt 1956 · S/N 28503 N5906AGnb Aviation LLC · Lake City, TNBuilt 1956 · S/N 28506 N5908APomeroy Cattle Ranch LLC · Kalispell, MTS/N 28508 N5909ARyan Michael W · Rincon, GABuilt 1956 · S/N 28509 N5910AAlumbaugh Ian M · Mcpherson, KSBuilt 1956 · S/N 28510 N5915AMyers Glen L · Grassy Butte, NDBuilt 1956 · S/N 28515 N5919AFederico Gilbert · Litchfield Park, AZBuilt 1956 · S/N 28519 N5920A20 Awesome LLC · Albuquerque, NMBuilt 1956 · S/N 28520 N5922AArmiger Scott L · Holly Springs, NCBuilt 1956 · S/N 28522 N5923ARowlett Glen R · Brookshire, TXBuilt 1956 · S/N 28523 N5927ASamaritans Purse · Boone, NCS/N 28527 N5928AToribio LLC · San Antonio, TXBuilt 1956 · S/N 28528 N5930AUthe Wendy G · Wellsville, MOBuilt 1956 · S/N 28530 N5932AAquila Aviation LLC · Pompano Beach, FLBuilt 1956 · S/N 28532 N5933AWicklander Richard O · Spanaway, WABuilt 1956 · S/N 28533 N5934AJenkins Brian T · Batesville, INBuilt 1956 · S/N 28534 N5935ADunn James Blair Jr · Bumpass, VABuilt 1956 · S/N 28535 N5938ALand-O-Matics LLC · Wilmington, DEBuilt 1956 · S/N 28538 N5943AFox Michael S · Glendale, AZS/N 28543 N5946AKessinger John · Independence, ORS/N 28546 N5947ARoberts James L · Sedgwick, KSBuilt 1956 · S/N 28547 N5948AVerdouw Andrew J · Georgetown, INBuilt 1956 · S/N 28548 N5950AVincent Anthony Jordan · Graham, KYBuilt 1956 · S/N 28550 N5952ARoberts Richard R · Seaman, OHBuilt 1956 · S/N 28552 N5956ATimes Of Refreshing World Outreach Ministry Inc · Baton Rouge, LABuilt 1956 · S/N 28556

Back to Cessna 172