Skip to content

Registered aircraft · 363

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

N8280XRegistration Pending · Archer Lodge, NCRegistration pendingBuilt 1961 · S/N 17248780 N8281XStull Carl · Phoenix, AZBuilt 1961 · S/N 17248781 N8283XWinfrey Walter A · Auburn, CABuilt 1961 · S/N 17248783 N8285XBerntsen Bradley T Trustee · Apple Valley, MNBuilt 1961 · S/N 17248785 N8287XMckeever Jesse M · Indio, CABuilt 1961 · S/N 17248787 N8288XLantana Beach Flying Club · West Palm Beach, FLBuilt 1961 · S/N 17248788 N8291XChandler Christopher G · Cooperstown, NYS/N 17248791 N8292XHeadings Daniel E · Salem, ORBuilt 1961 · S/N 17248792 N8294XFranco Stephen B · Chicago, ILBuilt 1961 · S/N 17248794 N8299XBeail Herschel D · Quincy, CAS/N 17248799 N8301XLindeman Rusty · D Hanis, TXBuilt 1961 · S/N 17248801 N8302XManley Stephen Edward · Carrabelle, FLBuilt 1961 · S/N 17248802 N8304XAeschliman Arlie W · Tribune, KSBuilt 1961 · S/N 17248804 N8310XBarah Inc · Wilmington, DEBuilt 1961 · S/N 17248810 N8312XPangerl Gary D · Mara, MNBuilt 1961 · S/N 17248812 N8313XJones Brian R · Turlock, CABuilt 1961 · S/N 17248813 N8314XEramo Jennilee · Fayetteville, NCBuilt 1961 · S/N 17248814 N8315XRozhon Richard J · Valparaiso, INBuilt 1961 · S/N 17248815 N8317XLittle Air Dream LLC · Mooresville, NCBuilt 1961 · S/N 17248817 N8320XHagovsky Thomas C · Attica, INBuilt 1961 · S/N 17248820 N8323XHumpage Jason H · Eugene, ORBuilt 1961 · S/N 17248823 N8324XJohnson Scott A · Missoula, MTBuilt 1961 · S/N 17248824 N8326XFlores Thomas E · Balch Springs, TXS/N 17248826 N8327XTwo Seven Xray LLC · Paradise Valley, AZS/N 17248827 N8328XPrevatt Richard T · Jacksonville, FLBuilt 1961 · S/N 17248828 N8332XFlight Instruction Inc · Central City, NEBuilt 1961 · S/N 17248832 N8333XBrownlee Mark B · Helena, MTBuilt 1961 · S/N 17248833 N8334XBumgarner Tommy J · Stanley, NCBuilt 1961 · S/N 17248834 N8337XMckay Jim · Camden, TNBuilt 1961 · S/N 17248837 N8338XSkiatook Flying Club LLC · Skiatook, OKBuilt 1962 · S/N 17248838 N8342XRoberts Jeremy C · Winchester, OHBuilt 1961 · S/N 17248842 N8343XHoward John D · Springfield, OHBuilt 1961 · S/N 17248843 N8346XMessinger Donald C · Wasilla, AKBuilt 1961 · S/N 17248846 N8349XRoberts Thomas Randy · Amarillo, TXBuilt 1961 · S/N 17248849 N8350XLee Daryl P · Poplarville, MSBuilt 1961 · S/N 17248850 N8351XSky Rangers Inc · Stockton, CAS/N 17248851 N8352XSchmid William J · Anchorage, AKBuilt 1961 · S/N 17248852 N8353XAcme Racing LLC · Overland Park, KSBuilt 1961 · S/N 17248853 N8354XWillow Equip LLC · Fox River Grove, ILBuilt 1961 · S/N 17248854 N8360XJk Sparks Inc · Lutz, FLBuilt 1961 · S/N 17248860 N8362XMarlow Haley C · Carrollton, MSS/N 17248862 N8363XKrause Alex E · Oklahoma City, OKS/N 17248863 N8366XAjm Aviation Ventures LLC · Seal Beach, CABuilt 1961 · S/N 17248866 N8367XLawrence Robert J · West Point, VABuilt 1961 · S/N 17248867 N8368XGay Morgan C · Tunkhannock, PABuilt 1961 · S/N 17248868 N8372AHegge Sharon D · Marysville, WABuilt 1962 · S/N 17249480 N8372XN8372x LLC · Chelan, WABuilt 1961 · S/N 17248872 N8373XPenrose Cory · Reno, NVBuilt 1941 · S/N 17248873 N8375XDugan Ronald C · Rogers City, MIBuilt 1961 · S/N 17248875 N8376XDraeger Joshua D · De Leon, TXBuilt 1961 · S/N 17248876

Back to Cessna 172C