Skip to content

Registered aircraft · 843

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

N34265Clc Aviation LLC · Springfield, MOS/N 17701739 N34273Downing Dennis L · Winter Haven, FLBuilt 1972 · S/N 17701741 N34274Nast Thomas B · Seattle, WABuilt 1972 · S/N 17701742 N34275Bishop Nina A · Gig Harbor, WAS/N 17701743 N34276Conlogue Walt R · Wilmington, NCBuilt 1972 · S/N 17701744 N34281Newman Richard T · Everett, WABuilt 1972 · S/N 17701746 N34283Tropical Flying Club LLC · Orlando, FLBuilt 1972 · S/N 17701748 N34284Ladd Michael · Umatilla, FLBuilt 1972 · S/N 17701749 N34285Peterson Scott · Morgantown, WVBuilt 1972 · S/N 17701750 N34286Pierce Ralph Anthony · Lake Mathews, CAS/N 17701751 N34287Satellite Beach Flying Club Inc · Melbourne, FLBuilt 1972 · S/N 17701752 N34288Registration Pending · Lakebay, WARegistration pendingBuilt 1972 · S/N 17701753 N34289Crone Steven M · Old Hickory, TNBuilt 1972 · S/N 17701754 N34302Romero John M · College Station, TXBuilt 1972 · S/N 17701757 N34308Greenwood Kevin · Tucson, AZBuilt 1972 · S/N 17701759 N34314Little James R Jr · East Carondelet, ILS/N 17701762 N34316Dane Ward LLC · Rising Fawn, GABuilt 1972 · S/N 17701764 N34320Eagle Sky Patrol Inc · Deadwood, SDBuilt 1972 · S/N 17701766 N34328Hamilton Thomas Arden · Lovettsville, VABuilt 1972 · S/N 17701767 N34343Wright Wayne M · Chestertown, MDBuilt 1972 · S/N 17701772 N34346Ball Donald · Hatfield, PABuilt 1972 · S/N 17701774 N34348Pingree Properties LLC · Hampshire, ILBuilt 1972 · S/N 17701775 N34358Leap Aviation Inc · Wilmington, DEBuilt 1972 · S/N 17701777 N3438SAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 17701784 N34405Jj&R Aero LLC · Winchester, INBuilt 1972 · S/N 17701787 N34407Registered aircraftS/N 17701788 N34411Jlh Aviation LLC · La Grange, TXBuilt 1972 · S/N 17701790 N34413Mms Flight LLC · Shawnee, KSBuilt 1972 · S/N 17701791 N34420Berman John L · Corvallis, ORS/N 17701794 N34427Cessna 177b Cardinal LLC · Prescott, AZBuilt 1972 · S/N 17701797 N34430Travland Christopher L · Austin, TXBuilt 1972 · S/N 17701798 N34432Wallace James K · Rio Rancho, NMBuilt 1972 · S/N 17701799 N34433Sowlemann Inc · Rockton, ILBuilt 1972 · S/N 17701800 N34442Valenti Alan · Bend, ORBuilt 1972 · S/N 17701805 N34443Schwitters Jerry · Clara City, MNS/N 17701806 N34444Lil Red Cardinal LLC · Phoenix, AZBuilt 1972 · S/N 17701807 N34445East Carolina Aviation LLC · Camden, NCBuilt 1972 · S/N 17701808 N34448Schleicher Conan A · Salem, ORBuilt 1972 · S/N 17701809 N34453Porcaro James · Latham, NYS/N 17701814 N34464Morgan Michael B · Stanwood, WAFirst renewal noticeBuilt 1972 · S/N 17701821 N34465Brodbeck William J · Kyle, TXBuilt 1972 · S/N 17701822 N34467Drust Joseph L · Menominee, MIBuilt 1972 · S/N 17701824 N34469Kroll Richard L · Kalamazoo, MIBuilt 1972 · S/N 17701826 N34471Grass Dennis Lee Trustee · Grass Valley, CABuilt 1972 · S/N 17701827 N34484Fingerhut Victor R Jr · Ponce, PRFirst renewal noticeBuilt 1972 · S/N 17701833 N34489Plexis Management Inc · Cheyenne, WYFirst renewal noticeBuilt 1972 · S/N 17701837 N34490Peterson Frazer C Trustee · Payette, IDBuilt 1972 · S/N 17701838 N34491Hazelwood Dennis L · Mount Vernon, MOBuilt 1972 · S/N 17701839 N34500Miller Judy Carole · No Palm Beach, FLBuilt 1972 · S/N 17701843 N34506Tibbs Gary R · Marietta, GABuilt 1972 · S/N 17701846

Back to Cessna 177B