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.

N714ZCMauser William T · Rio Linda, CABuilt 1977 · S/N 15279553 N714ZGNotam Aviation LLC · Portage Des Sioux, MOBuilt 1977 · S/N 15279557 N714ZPDippold Lois M · Perry, MIBuilt 1977 · S/N 15279564 N714ZUJet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15279569 N714ZXWagner Michael · Winter, WIBuilt 1977 · S/N 15279572 N714ZYCoco Aircraft Inc · Merritt Island, FLBuilt 1978 · S/N 15282152 N715TLucy Roy · Ada, OKFirst renewal noticeBuilt 1977 · S/N 15279611 N723CMOmbra Aria LLC · Dover, DEBuilt 1978 · S/N 15282823 N723THSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 15281348 N745FWWalther Frank C · Crawford, COBuilt 1980 · S/N 15283905 N747ZPAuburn Valley LLC · Farmington, MNBuilt 1977 · S/N 15279476 N757AAHeavy Metal Air LLC · Farmingdale, NYBuilt 1977 · S/N 15279575 N757ABCallum James M · Newport, NHBuilt 1977 · S/N 15279576 N757ADLong Island Aviators LLC · Seaford, NYBuilt 1977 · S/N 15279578 N757AHRed Sky Aviation LLC · Livermore, CABuilt 1977 · S/N 15279582 N757AJSunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15279583 N757AYAdams Steve G · Watsonville, CABuilt 1977 · S/N 15279597 N757AZKilo Aviation LLC · East Peoria, ILS/N 15279598 N757BBKelley Aircraft LLC · Weyers Cave, VABuilt 1977 · S/N 15279600 N757BFOld Goat LLC · Wilmington, DEBuilt 1977 · S/N 15279604 N757BKPfister Mark A · Acworth, GABuilt 1977 · S/N 15279608 N757BS4 One Air LLC · Holland, MIBuilt 1977 · S/N 15279615 N757BVPlayer Dennis M · Union Bridge, MDS/N 15279618 N757BWK2 Sales LLC · Idaho Falls, IDS/N 15279619 N757CQPorter Casey · Bluffton, SCBuilt 1977 · S/N 15279636 N757CSBowers Scott · Mc Donald, PABuilt 1977 · S/N 15279638 N757CTAero Fliers LLC · Kalispell, MTBuilt 1977 · S/N 15279639 N757DAHuston Wes · Sanger, TXBuilt 1977 · S/N 15279646 N757DEMavity Michael D · Phoenix, AZBuilt 1977 · S/N 15279650 N757DFWisener Lupita A · Mineola, TXBuilt 1977 · S/N 15279651 N757DQIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1977 · S/N 15279660 N757DTStar City Aviation Inc · Roanoke, VAS/N 15279663 N757EHWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279677 N757ENMontana Flying Service LLC · Missoula, MTBuilt 1977 · S/N 15279682 N757EVRoth Michael L · Lanse, MIBuilt 1977 · S/N 15279689 N757EWMagin Sonny K · Harvest, ALS/N 15279690 N757EXRound Engine Aero · Nashville, MIS/N 15279691 N757FCBoland Matthew S · Anchorage, AKBuilt 1977 · S/N 15279696 N757FDR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15279697 N757FEMock Joseph R · Huntsville, TXBuilt 1977 · S/N 15279698 N757FFAir-Planes LLC · Soddy Daisy, TNS/N 15279699 N757FHSilverman Mitchell G · Cumberland, RIBuilt 1977 · S/N 15279701 N757FJGeorge Alexander Vasil Jr · Haverhill, MABuilt 1977 · S/N 15279702 N757FQMundis William L · York, PABuilt 1977 · S/N 15279708 N757GNExecutive Wings LLC · Bolivar, TNBuilt 1977 · S/N 15279730 N757GQAngel Aviation Inc · Peoria, AZBuilt 1977 · S/N 15279732 N757GXWinging It Aviation Two LLC · Gulf Shores, ALBuilt 1977 · S/N 15279739 N757HAKim Sungtae · Fort Worth, TXS/N 15279742 N757HCBaker David L · Leavenworth, KSBuilt 1977 · S/N 15279744 N757HERussell Robert Q · Genoa City, WIBuilt 1977 · S/N 15279746

Back to Cessna 152