Skip to content

Registered aircraft · 857

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

N19706S&S Aircraft Inc · Bennington, VTBuilt 1972 · S/N 17260687 N19707Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260688 N19709Lewis Michael E · Carmel, INBuilt 1972 · S/N 17260690 N19710Bremfour Aviation Group Inc · Wilmington, DEBuilt 1972 · S/N 17260691 N19711Conetta Gregory J · Kinnelon, NJBuilt 1972 · S/N 17260692 N19717Roth Mark E · Stevensville, MTBuilt 1972 · S/N 17260695 N19719Kejr Melvin P · Salina, KSBuilt 1972 · S/N 17260697 N19720Gooney Bird LLC · Chandler, AZBuilt 1972 · S/N 17260698 N19722Autumn Transportation LLC · Nashville, TNBuilt 1972 · S/N 17260699 N19727Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260702 N19729Canale Anthony · Friendswood, TXBuilt 1972 · S/N 17260704 N19730Terrasi John D · Pittsfield, PABuilt 1972 · S/N 17260705 N19731Valiair Lc Trustee · Casper, WYBuilt 1972 · S/N 17260706 N19733Jones Darrell W · Kennett, MOBuilt 1972 · S/N 17260707 N19736Friendship Mark · Topanga, CABuilt 1972 · S/N 17260710 N19739Breen Peter Herschel · Irvine, CABuilt 1972 · S/N 17260713 N19740Hendrickson David O · Crab Orchard, KYBuilt 1972 · S/N 17260714 N19742Four Hearts Farm LLC · Sunbury, OHBuilt 1972 · S/N 17260715 N19746Kingdom Aviation Group LLC · Thomasville, GABuilt 1972 · S/N 17260717 N19747Chase Tyler D · Ephrata, WABuilt 1972 · S/N 17260718 N19749Curry Kim M · Griggsville, ILBuilt 1972 · S/N 17260720 N19751Alaska Farm Tours LLC · Palmer, AKS/N 17260721 N19752Platt Aaron · Heppner, ORBuilt 1972 · S/N 17260722 N19753Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 17260723 N19754Michael J Lefave Cpa Apc · Three Rivers, CABuilt 1972 · S/N 17260724 N19757Kalamir Richard · Valparaiso, INBuilt 1972 · S/N 17260726 N19760Aero Assn Of California Institute Of Technology · Pasadena, CABuilt 1972 · S/N 17260729 N19766Owens Wilbur · Rch Palos Vrd, CAS/N 17260734 N19768Glacier Flight Training LLC · Whitefish, MTS/N 17260736 N19771Tetoff Logan P · Bethel, AKBuilt 1972 · S/N 17260739 N19773Burtch Timothy J · Washington, DCBuilt 1972 · S/N 17260740 N19775Skyhawk Leasing LLC · Odenville, ALBuilt 1972 · S/N 17260742 N19777Rtd Aviation LLC · Hillsborough, NJBuilt 1972 · S/N 17260744 N19778Marx John C · Edgewood, WABuilt 1972 · S/N 17260745 N19781Carbono Alvaro J · Valdez, AKBuilt 1972 · S/N 17260746 N19789Remhof Marc · Inver Grove, MNBuilt 1972 · S/N 17260753 N19791Smithburg Richard · Lockridge, IABuilt 1972 · S/N 17260755 N19792Dunfee Dalton M Trustee · Corinth, MEBuilt 1972 · S/N 17260756 N19794Lasater John M G · Grants Pass, ORBuilt 1972 · S/N 17260758 N1TAJustine Lorraine F · Newark, DEBuilt 1972 · S/N 17260453 N2114XGsi Corp · Eastham, MABuilt 1970 · S/N 17259495 N218EABauer Todd A · Kenmare, NDBuilt 1970 · S/N 17259583 N221DMRush Aviation LLC · Melrose, NMBuilt 1971 · S/N 17260155 N232LSElliott Arthur M · Portland, TXBuilt 1971 · S/N 17260131 N23MZGulfstream Media LLC · Daytona Beach, FLBuilt 1972 · S/N 17260459 N241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889 N242AVN242av LLC · Manassas, VABuilt 1972 · S/N 17260470 N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205 N2511798x LLC · Caddo Mills, TXBuilt 1970 · S/N 17259514 N269CJLarson Martin B · Rapid City, SDBuilt 1970 · S/N 17259512

Back to Cessna 172L