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.

N532RSZacherl Randall L · Indiana, PABuilt 1980 · S/N 15284322 N5335PFlying Vikings Inc · Hayward, CABuilt 1981 · S/N 15284919 N5337LFather Son Ing LLC · Wilmington, DEBuilt 1980 · S/N 15284296 N5337PHanson David J · Elgin, TXBuilt 1981 · S/N 15284920 N53380Haltom Gary D · Alva, OKS/N 15283540 N5339BFiebig Howard J · Sebewaing, MIBuilt 1979 · S/N 15283841 N5342PSp Airparts LLC · Moscow, IDBuilt 1981 · S/N 15284921 N5344BJohn Annin LLC · Fenton, MOBuilt 1979 · S/N 15283843 N5344MPinger Kevin R · Palo Alto, CABuilt 1980 · S/N 15284548 N5345MNew Orleans Aerial Tours & Flight Training LLC · New Orleans, LABuilt 1980 · S/N 15284549 N5348BBowers Curt E · Jennings, LABuilt 1979 · S/N 15283844 N5350MNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1980 · S/N 15284553 N5350PChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15284924 N5351LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284298 N5351PPointair Aviation Inc · Port Jeff Sta, NYS/N 15284925 N5353HDe Nunzio Arnold J · Ballard, CABuilt 1979 · S/N 15284090 N5355PPittsburgh Pilot Training LLC · Bethel Park, PABuilt 1981 · S/N 15284926 N5355QGorge Winds Aviation Inc · Fairview, ORBuilt 1981 · S/N 15285104 N5357HRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15284092 N5357PSunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15284927 N5364POwens Flight Training LLC · Lafayette, LABuilt 1981 · S/N 15284929 N5366MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284566 N5368MPacific Union College · Angwin, CABuilt 1980 · S/N 15284567 N5369HValdiosera Octavio · Tracy, CABuilt 1980 · S/N 15284094 N5378BDraper Floyd L · El Paso, TXBuilt 1979 · S/N 15283855 N5383MSunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15284572 N5384PKs Aviation Inc · Atwater, CABuilt 1981 · S/N 15284934 N5387BHuffman Jacob M III · Burleson, TXBuilt 1979 · S/N 15283857 N5389MChapel Hill Flying Club DBA · Sanford, NCBuilt 1980 · S/N 15284576 N5389QCieri Joe · Graves Mill, VABuilt 1981 · S/N 15285107 N5394BRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15283859 N5399BLudian Malgorzata · Bakersfield, CABuilt 1979 · S/N 15283861 N539BXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 15283898 N5403HWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15284096 N5404BRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15283862 N5405BNatkat Aviation Services LLC · Finleyville, PABuilt 1979 · S/N 15283863 N5405MToozer Air LLC · Ormond Beach, FLBuilt 1980 · S/N 15284581 N5416BLong Island Aviators LLC · Seaford, NYS/N 15283867 N5420POklahoma State University · Stillwater, OKBuilt 1981 · S/N 15284942 N5421PRiverside Flight Center Inc · Tulsa, OKBuilt 1981 · S/N 15284943 N5428LMacair Aviation LLC · Xenia, OHBuilt 1980 · S/N 15284313 N5442BWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283870 N5443LCp Aviation Inc · Santa Paula, CABuilt 1980 · S/N 15284315 N5447LPinnacle Aviation Services Inc · Encinitas, CABuilt 1980 · S/N 15284317 N5448LSantorini Services LLC · Washington, DCS/N 15284318 N5450QCruise Flight Academy Inc · Dalton, GABuilt 1981 · S/N 15285112 N5453MQueen City Flying Club LLC · Cincinnati, OHBuilt 1980 · S/N 15284590 N5458PLoewenstein Edward B · Austin, TXBuilt 1981 · S/N 15284949 N5460BSkyway Inc · Wilmington, DES/N 15283875 N5461HWhitson Johnny E · Cleveland, TXBuilt 1979 · S/N 15284102

Back to Cessna 152