Skip to content

Registered aircraft · 718

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

N8735UJkh Aviation LLC · Cumming, GABuilt 1965 · S/N 17252639 N8736UC & M Aviation Holdings LLC · Brockport, NYBuilt 1965 · S/N 17252640 N8737UMiss Lou Flight LLC · Vidalia, LABuilt 1965 · S/N 17252641 N8739UAndrews Willard R · Windham, MEBuilt 1965 · S/N 17252643 N8741USexton Mathew G · Rockwell City, IABuilt 1965 · S/N 17252645 N8742UJennings Jeff L · Kenly, NCS/N 17252646 N8749UHendrickson Flying Service Inc · Rochelle, ILBuilt 1965 · S/N 17252653 N8750UHenryetta Airman Inc · Morris, OKBuilt 1965 · S/N 17252654 N8752UFarm Air Corp · Hoxie, ARBuilt 1965 · S/N 17252656 N8753USowash Allan D · Ontario, OHBuilt 1965 · S/N 17252657 N8757ULewis County Flying Club · Lewistown, MOBuilt 1965 · S/N 17252661 N8759UKelly Cynthia · Sealy, TXBuilt 1965 · S/N 17252663 N8761USmith Dustin T · Jasper, GABuilt 1965 · S/N 17252665 N8762UBelli Christopher J · Oregon, OHBuilt 1965 · S/N 17252666 N8768UWright Roland P · Detroit, MIBuilt 1965 · S/N 17252672 N876WFries Jeffery A · Paw Paw, MIBuilt 1965 · S/N 17253293 N8773URegistration Pending · Scotch Plains, NJRegistration pendingBuilt 1965 · S/N 17252677 N877TFMattingly Bruce A · Morehead, KYBuilt 1965 · S/N 17252674 N8781UHalsey Gene L · Huron, SDBuilt 1965 · S/N 17252685 N8786USchlosser Bryan Andrew · Sudlersville, MDBuilt 1965 · S/N 17252691 N8787UMoody Bible Institute Of Chicago · Spokane, WAS/N 17252692 N8788UIzard Ryan S · Nacogdoches, TXS/N 17252693 N87DRegistration Pending · Ashville, NYRegistration pendingBuilt 1965 · S/N 17253345 N8800UWright Flight Inc · Tucson, AZBuilt 1965 · S/N 17252706 N8801UBarnett David · Brock, TXBuilt 1965 · S/N 17252707 N8802UWoods Helen · Laurel, MDBuilt 1965 · S/N 17252708 N8803UDale David J · North Fort Myers, FLBuilt 1965 · S/N 17252709 N8804UParadox Investments Pacnw LLC · San Antonio, TXBuilt 1965 · S/N 17252710 N8808UValiair Limited Company Trustee · Casper, WYS/N 17252715 N8810UWebesharing LLC · Orange Beach, ALBuilt 1965 · S/N 17252717 N8811UAlder William D III · Athens, OHBuilt 1965 · S/N 17252718 N8813UAerios Air LLC · Midland, TXBuilt 1965 · S/N 17252720 N8816UHocus Holdings LLC · Carrollton, OHBuilt 1965 · S/N 17252723 N8818UUfford Christian T · Vershire, VTBuilt 1965 · S/N 17252725 N8819UBoss Gary W · Bronston, KYBuilt 1965 · S/N 17252726 N8821UEuros Aircraft Leasing LLC · College Station, TXBuilt 1965 · S/N 17252729 N8823UCookenmaster Christal · Arley, ALBuilt 1965 · S/N 17252731 N8825URosdahl Steve R · Maple Plain, MNBuilt 1965 · S/N 17252733 N8833USchreiber George J IV · Olean, NYS/N 17252743 N8834UHudson Valley Aviation LLC · Campbell Hall, NYBuilt 1965 · S/N 17252744 N8836UWhite Charles A · Rch Palos Vrd, CABuilt 1965 · S/N 17252746 N8839USchuh Thomas M · Queen Creek, AZBuilt 1965 · S/N 17252750 N8840UHathor Aviation LLC · Johnstown, COBuilt 1965 · S/N 17252751 N8841UNorcal Flight Center LLC · Lincoln, CABuilt 1966 · S/N 17252752 N8842UHwa LLC · Charleston, SCBuilt 1965 · S/N 17252753 N8843UGullatt Jamey D · Mount Airy, NCBuilt 1965 · S/N 17252754 N8846USmith Chad · Boulder City, NVBuilt 1965 · S/N 17252758 N8856UKnutson Wayne R · Thompson, NDBuilt 1965 · S/N 17252770 N8858UHolbrook Joel P · Delta Junction, AKBuilt 1965 · S/N 17252772 N8861UBlanchard Donald P Jr · Napoleonville, LABuilt 1965 · S/N 17252775

Back to Cessna 172F