Skip to content

Registered aircraft · 1,300

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 ('2072306', '2072307')
  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 ('2072306', '2072307')
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.

N1719DHurd Matthew · Recluse, WYBuilt 1952 · S/N 20342 N173RJJohnston Ronald E · Seattle, WAS/N 26269 N1743DCranton Larry J · Mesa, AZBuilt 1952 · S/N 20343 N1782DRegistration Pending · Homer, AKRegistration pendingS/N 20350 N17TBOwen Bertha C · Port Saint Lucie, FLBuilt 1955 · S/N 27067 N17ZSContinental Title Trust Co Trustee · Wichita, KSS/N 26632 N1801CRollins Michael Clayton · Pine River, MNS/N 25945 N1803CWallner David A · Adell, WIBuilt 1953 · S/N 25947 N1805CCampbell Stacy D · Buena Vista, COBuilt 1953 · S/N 25949 N1807CMorriss Elvin A · Springdale, ARBuilt 1952 · S/N 25951 N1808MPenner Paul R · Bel Air, MDS/N 25952 N1811CEastburn Maurice H · Peyton, COBuilt 1953 · S/N 25955 N1816CCalvert Tobin R · San Antonio, TXBuilt 1953 · S/N 25960 N1819CFischer Douglas J · Palermo, CAS/N 25963 N1824CFindlay Mark W · Anchorage, AKBuilt 1953 · S/N 25968 N1828CAnderson Christopher S · Wasilla, AKBuilt 1953 · S/N 25972 N1830CV1 Air Inc · Hibbing, MNS/N 25974 N1831CRoesbery Charles J · Cordova, AKBuilt 1953 · S/N 25975 N1832CBohl Howard M · Temecula, CABuilt 1953 · S/N 25976 N1838CMcdevitt Daniel C · Social Circle, GABuilt 1953 · S/N 25982 N1839COploh Elli M · Makanda, ILBuilt 1953 · S/N 25983 N1842CSmith Ronald Raymond · Willows, CABuilt 1953 · S/N 25986 N1846CNorthwest Intl Aviation · Seattle, WABuilt 1953 · S/N 25990 N1853CDavidson Gregg C · Pioneer, CAFirst renewal noticeBuilt 1953 · S/N 25997 N1854CBurns Linda J · Vernon, MIBuilt 1953 · S/N 25998 N1855CRowe James D · Nome, AKBuilt 1953 · S/N 25999 N1857CSchlender Michael E · Clintonville, WIBuilt 1953 · S/N 26001 N1861CSierra Flying Club LLC · Woodinville, WABuilt 1953 · S/N 26005 N1862CCoffey Calvin A · Mckinney, TXBuilt 1953 · S/N 26006 N1863CWalch Brian A · Anchorage, AKBuilt 1953 · S/N 26007 N1864CRegistered aircraftBuilt 1953 · S/N 26008 N1869CSale Reported · Gorham, MESale reportedBuilt 1953 · S/N 26013 N1873COrion Aviation Aircraft LLC · Carlsbad, CABuilt 1953 · S/N 26017 N1876CRichardson Todd G · Olalla, WABuilt 1953 · S/N 26020 N1879CWallick Philip L · Chico, CABuilt 1953 · S/N 26023 N1881CAmaryllis Living LLC · Tampa, FLS/N 26025 N1885CZibell David H · Olympia, WABuilt 1953 · S/N 26029 N1887CRiggs Eugene D · Shoreline, WAS/N 26031 N1888CWayman Ian A · Peyton, COBuilt 1953 · S/N 26032 N1889CKlindworth Bo N · Beulah, NDBuilt 1953 · S/N 26033 N188CRempfer David Dwayne · Chandler, AZS/N 27104 N1891CCoetzee Theo · San Luis Obispo, CABuilt 1953 · S/N 26035 N1893CFife Christopher R · Winslow, MEBuilt 1953 · S/N 26037 N1896CGladish Jeffrey · Terrell, TXBuilt 1953 · S/N 26041 N1897CBentley Eric T · Farmersville, TXBuilt 1953 · S/N 26042 N1899CBarron Jon M · Perry, MOBuilt 1953 · S/N 26044 N1906CHolcomb Garry M · Point, TXS/N 26051 N1909CSwanke Mark · West Ossipee, NHBuilt 1953 · S/N 26054 N1910CStagnito Kollin · Frederick, MDBuilt 1953 · S/N 26055 N1912CN1912c Flyers LLC · Guymon, OKBuilt 1953 · S/N 26057

Back to Cessna 170B