Skip to content

Registered aircraft · 1,636

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

N95475Kent State University · Stow, OHBuilt 1984 · S/N 15285902 N954SASunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280626 N95537High Expectations LLC · Wilmington, DEBuilt 1984 · S/N 15285916 N95539Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1984 · S/N 15285917 N95551Florida Flight Training Center · Venice, FLBuilt 1984 · S/N 15285919 N95556Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1984 · S/N 15285922 N95606Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1984 · S/N 15285936 N95615Li LLC · Seattle, WABuilt 1984 · S/N 15285938 N95626Smith Charles · Hays, NCBuilt 1984 · S/N 15285943 N95639Barbee Donald · Columbus, OHS/N 15285949 N95646Advantage Aviation Inc · Palo Alto, CABuilt 1985 · S/N 15285951 N95670Board Of Trustees Of Southern Illinois Univ DBA · Murphysboro, ILBuilt 1985 · S/N 15285957 N956ERZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 15282201 N95722Frick Gregory A · Portland, ORBuilt 1985 · S/N 15285962 N95737Kent State University · Stow, OHBuilt 1985 · S/N 15285964 N95787Wisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1985 · S/N 15285967 N95797Kent State University · Stow, OHBuilt 1985 · S/N 15285968 N95821Kent State University · Stow, OHBuilt 1985 · S/N 15285970 N95831Space Coast Aircraft Co · Merritt Island, FLBuilt 1985 · S/N 15285972 N95840Lane Community College · Eugene, ORBuilt 1985 · S/N 15285973 N95936Scholey Todd A · Vacaville, CABuilt 1985 · S/N 15285987 N95993Delta State University · Cleveland, MSBuilt 1985 · S/N 15285996 N95995Hagele Aviation LLC · Hillsboro, ORBuilt 1985 · S/N 15285997 N959GTR&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15282116 N96092Florida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1985 · S/N 15286006 N96096Jwa Flight School LLC · Bolingbrook, ILBuilt 1985 · S/N 15286007 N963MSMount San Antonio College · Walnut, CABuilt 1982 · S/N 15285655 N963WAChase Kenneth C Jr · Rochester, MNS/N 15282882 N965AAWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282465 N968MSMount San Antonio College Associated · Walnut, CABuilt 1977 · S/N 15281080 N970SETraining Planes LLC · Tampa, FLBuilt 1979 · S/N 15283609 N971FMFreeway Airport Inc · Mitchellville, MDBuilt 1977 · S/N 15281185 N9733ACloud Dancer Aviation Inc · Deland, FLBuilt 1978 · S/N 15281329 N994RSShane Richard D · Canandaigua, NYBuilt 1978 · S/N 15282505 N99HRSilver Express Co · Miami, FLBuilt 1978 · S/N 15282972 N9KAEssex Aviation · Indianapolis, INS/N 15284552

Back to Cessna 152