Skip to content

Registered aircraft · 435

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

N7200TYavitch Barry E · Palmdale, CABuilt 1959 · S/N 46800 N7201THorton Rusty Ray · Monroe, GABuilt 1959 · S/N 46801 N7202TArcangeli Harry L · Lakemont, NYBuilt 1959 · S/N 46802 N7203TRegistration Pending · Amarillo, TXRegistration pendingBuilt 1959 · S/N 46803 N7206TSimmons William E · Port Orchard, WABuilt 1959 · S/N 46806 N7207TMrzena Matthew D · Wasilla, AKBuilt 1959 · S/N 46807 N7209TBouchez Lawrence T · Manhattan Beach, CABuilt 1959 · S/N 46809 N7214TKennedy John M · San Leandro, CABuilt 1960 · S/N 46814 N7215TSmith Jon O · Leavenworth, WAFirst renewal noticeBuilt 1959 · S/N 46815 N7216TRk Air LLC · Wilmington, DEBuilt 1959 · S/N 46816 N7217TDenney David W · Fowler, COS/N 46817 N7218TTwilley Reginald M · Mobile, ALFirst renewal noticeBuilt 1959 · S/N 46818 N7219TScott Gregory R · Kennesaw, GABuilt 1959 · S/N 46819 N7221TDahle Neil E · Mason City, IABuilt 1959 · S/N 46821 N7222TRegistration Pending · Lawndale, CARegistration pendingBuilt 1959 · S/N 46822 N7223TRoberts Michael R · Plano, TXBuilt 1959 · S/N 46823 N7226TCreasman Zane V · Arden, NCBuilt 1959 · S/N 46826 N7229TSmith Carl L · Vinita, OKS/N 46829 N7241TSelleck Philip A · Falls Church, VABuilt 1959 · S/N 46841 N7242TDenton David · Siloam Springs, ARBuilt 1959 · S/N 46842 N7244TFlood John M · Bozeman, MTBuilt 1959 · S/N 46844 N7245TWestfall James H · Bend, ORBuilt 1959 · S/N 46845 N7246TKruger Bruce W · Gustavus, AKS/N 46846 N7247TNelson Harold G · Pendleton, ORBuilt 1959 · S/N 46847 N7248TStormont Dylan · Xenia, OHS/N 46848 N7258TAutry Stephen W · Durango, COBuilt 1959 · S/N 46858 N7259THarrington Everett Dean · Council, IDBuilt 1959 · S/N 46859 N7263TScheler Thomas · Independence, ORS/N 46863 N7265TKor Aviation LLC · Piedmont, SDBuilt 1959 · S/N 46865 N7268TParker Harold E · Cabot, ARFirst renewal noticeBuilt 1959 · S/N 46868 N7270TBudenbender Philip W · Weatherford, TXBuilt 1959 · S/N 46870 N7274TN8653u LLC · Fairbanks, AKBuilt 1959 · S/N 46874 N7275TBeets Larry Joe · Columbia, MSBuilt 1959 · S/N 46875 N7276TBraner Richard C Trustee · Oakdale, CABuilt 1959 · S/N 46876 N7277TStrehler Stanford L · League City, TXBuilt 1959 · S/N 46877 N7278TChudy Daniel B · Yucaipa, CAS/N 46878 N7281TBreier Clifford G · Dardanelle, ARBuilt 1959 · S/N 46881 N7287TRfk Aerospace LLC · Clayton, NCBuilt 1959 · S/N 46887 N7288TSandusky Flight Academy LLC · Sandusky, MIBuilt 1959 · S/N 46888 N7289TShepherd Gary D · Owosso, MIBuilt 1959 · S/N 46889 N7291TThomas Charles A · Hockley, TXBuilt 1959 · S/N 46891 N7292TObloy James J · Brunswick, OHBuilt 1959 · S/N 46892 N7293TMccamant Angus J · Alohu, ORBuilt 1959 · S/N 46893 N7294TBurnett Albert Franklin · Lubbock, TXS/N 46894 N7296TTurner Clinton C · Springdale, ARBuilt 1959 · S/N 46896 N7299TOstrowski Sven E · Mullica Hill, NJBuilt 1959 · S/N 46899 N729WDMonroe Greg · Linden, TNBuilt 1960 · S/N 47583 N7301THolte Martin W · Burnsville, MNBuilt 1959 · S/N 46901 N7302TSchaff James F · Prescott, AZBuilt 1959 · S/N 46902 N7306TFaull Ron W · Sandpoint, IDS/N 46906

Back to Cessna 172A