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.

N94500Training Planes LLC · Tampa, FLBuilt 1983 · S/N 15285692 N94505Riverside Flight Center Inc · Tulsa, OKBuilt 1983 · S/N 15285696 N94513Hampden Aviation Services Inc · Northampton, MABuilt 1983 · S/N 15285702 N94528Daedalus Flight School Inc · P. FokaiaS/N 15285705 N94532Oklahoma State University · Stillwater, OKFirst renewal noticeBuilt 1983 · S/N 15285707 N94553Delta State University · Cleveland, MSBuilt 1983 · S/N 15285718 N94569Chester Charter Inc · Chester, CTBuilt 1983 · S/N 15285731 N94570Richmor Aviation Inc · Hudson, NYBuilt 1983 · S/N 15285732 N94573Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1983 · S/N 15285735 N94577Ace Aircraft Leasing Inc · Nazareth, PABuilt 1983 · S/N 15285736 N94584Sale Reported · West Lafayette, INSale reportedBuilt 1983 · S/N 15285738 N94585Aviation Trade Inc · Castroville, TXBuilt 1983 · S/N 15285739 N94589Haverlock Aircraft LLC · Willoughby, OHBuilt 1983 · S/N 15285740 N945KMSkypros East Kansas City · Grain Valley, MOBuilt 1977 · S/N 15280816 N94609Heavy Metal Air LLC · Farmingdale, NYBuilt 1983 · S/N 15285742 N94626New Horizons Aviation Inc · Goshen, INS/N 15285747 N94652Maryak Hans F · Somersworth, NHBuilt 1983 · S/N 15285752 N94655Iowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1983 · S/N 15285753 N94659Pavco Inc · Gig Harbor, WABuilt 1983 · S/N 15285755 N94661Fjiro Aviation N94661 LLC · Vancouver, WAFirst renewal noticeBuilt 1983 · S/N 15285756 N94684Delta State University · Cleveland, MSBuilt 1983 · S/N 15285763 N94688Lyon Aviation Inc · Pittsfield, MABuilt 1983 · S/N 15285765 N946ACNaples Air Center Inc · Naples, FLBuilt 1985 · S/N 15286018 N946SFSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282353 N94714Wright Aero Inc · Saint Cloud, MNBuilt 1983 · S/N 15285771 N94768Indian River Flying Club Inc · Rockledge, FLBuilt 1983 · S/N 15285782 N94790Kingsky Flight Academy LLC · Lakeland, FLS/N 15285788 N947SFSnohomish Flying Service Inc · Snohomish, WABuilt 1983 · S/N 15285770 N94822Elon Aviation LLC · Burlington, NCBuilt 1983 · S/N 15285795 N94891Avcorp Holdings Inc · Jackson, MIBuilt 1983 · S/N 15285806 N9494GKelly William W · Springfield, ORBuilt 1977 · S/N 15279527 N94959Lane Community College · Eugene, ORBuilt 1983 · S/N 15285823 N94963Twin Cities Air Service LLC · Gray, MES/N 15285825 N95005Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 15285835 N95021Space Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 15285838 N95031Pratt John · Anchorage, AKBuilt 1984 · S/N 15285841 N95103Shelton Aviation Inc · Christiansburg, VABuilt 1984 · S/N 15285849 N95122Mcnamara Kevin M Jr · East Aurora, NYBuilt 1984 · S/N 15285852 N95159Kinne Dagmar · Woodburn, ORBuilt 1984 · S/N 15285860 N95374Board Of Trustees DBA · Murphysboro, ILBuilt 1984 · S/N 15285879 N95391Training Planes LLC · Tampa, FLBuilt 1984 · S/N 15285881 N953SASunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15283908 N95404Delta State University · Cleveland, MSBuilt 1984 · S/N 15285887 N95429Suburban Air Corp · Castro Valley, CABuilt 1984 · S/N 15285892 N95431Kent State University · Stow, OHBuilt 1984 · S/N 15285893 N95435Bird Acquisition LLC · Phoenix, AZFirst renewal noticeS/N 15285895 N95444Kent State University · Stow, OHBuilt 1984 · S/N 15285897 N95445Kent State University · Stow, OHBuilt 1984 · S/N 15285898 N95469Kent State University · Stow, OHBuilt 1984 · S/N 15285899 N95474Kent State University · Stow, OHBuilt 1984 · S/N 15285901

Back to Cessna 152