Skip to content

Registered aircraft · 353

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

N584SFDsr Cherokee 180 LLC · Dallas, TXBuilt 1968 · S/N 17256834 N633WGWings Of Grace Ministries Inc · Melbourne, FLBuilt 1968 · S/N 17256670 N687AZZublin John A III · Murrieta, CABuilt 1968 · S/N 17256592 N702GTsiouklas Aviation Inc · Dunedin, FLBuilt 1968 · S/N 17256919 N709MWGrant Michael R · South Weber, UTBuilt 1968 · S/N 172-56629 N727LGYouth & Aviation Inc · Thiensville, WIBuilt 1968 · S/N 17256938 N727SFRenko Steven E · Elmira, NYBuilt 1968 · S/N 17256791 N77DHBramon Bruce M · Sunrise Beach, MOBuilt 1968 · S/N 17257127 N800FCFargo Curt J · Vacaville, CAS/N 17256726 N816LRegistration Pending · Anderson, SCRegistration pendingBuilt 1968 · S/N 17256833 N8316LCorletto Carlos · Bermuda Dunes, CABuilt 1968 · S/N 17256516 N8317LWalker Paul R · Ursa, ILBuilt 1968 · S/N 17256517 N8319LLaudon Piper C · Anchorage, AKS/N 17256519 N8331LMjl Investment Company Inc · Branchville, NJBuilt 1968 · S/N 17256531 N8333LLedford Daniel R · Granbury, TXBuilt 1968 · S/N 17256533 N8334LAirspeed Marketing Bravo LLC · Phoenix, AZBuilt 1968 · S/N 17256534 N8338LTreimer Aviation LLC · Davenport, IABuilt 1968 · S/N 17256538 N8339LRohrbaugh David J · Oakland, MDBuilt 1968 · S/N 17256539 N8340LHess Garrett J · Fullerton, CABuilt 1968 · S/N 17256540 N8344LHeir Borne Flying Club Inc · Minot, NDBuilt 1968 · S/N 17256544 N8346LJones Mark B · Angleton, TXBuilt 1968 · S/N 17256546 N8347LSchye Ted E · Billings, MTBuilt 1968 · S/N 17256547 N8348LPrice William B · Lamar, SCBuilt 1968 · S/N 17256548 N8351LPlane Junkies LLC · Dover, DEBuilt 1968 · S/N 17256551 N8352LFielding David · Scarborough, MES/N 17256552 N8354LEast Texas Imperial Petroleum LLC · Flint, TXBuilt 1968 · S/N 17256554 N8358LOc Flight Lessons LLC · Costa Mesa, CABuilt 1968 · S/N 17256558 N8359LBay Lux Ventures LLC · Tampa, FLS/N 17256559 N8361LMolid Robert J · Dubuque, IABuilt 1968 · S/N 17256561 N8365LHarbour Aviation LLC · Weatherford, TXBuilt 1968 · S/N 17256565 N8366LCurwin Randy S · Villa Rica, GABuilt 1968 · S/N 17256566 N8367LRay Allens Electronics Inc · Butler, GABuilt 1968 · S/N 17256567 N8368LMeltzair LLC · Fryeburg, MEBuilt 1968 · S/N 17256568 N8369LInternational Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17256569 N8372LRed Sky Aviation LLC · Livermore, CABuilt 1968 · S/N 17256572 N8373LFaulkner Jeannine P · Bethel, AKFirst renewal noticeBuilt 1968 · S/N 17256573 N8374LGeneral Aviation LLC · Henderson, NVBuilt 1968 · S/N 17256574 N8378LLett Brian R · Eden Prairie, MNBuilt 1968 · S/N 17256578 N8379LSan Fernando Aviation LLC · Van Nuys, CAS/N 17256579 N8381LShielded Holdings LLC - Series Av 12 · Katy, TXBuilt 1968 · S/N 17256581 N8382LMedina Solla Edwin O · Trujillo Alto, PRBuilt 1968 · S/N 17256582 N8385LKrebs Lisa Christine · Homer, AKBuilt 1968 · S/N 17256585 N8386LAdams Haidyn · Pentwater, MIS/N 17256586 N8387LSerra Christopher R · Snellville, GABuilt 1968 · S/N 17256587 N8389LJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 17256589 N8390LBliss Marketing Communications Inc · Phoenix, AZBuilt 1968 · S/N 17256590 N8393LJohns Ryan · Sabillasville, MDBuilt 1968 · S/N 17256593 N8398LWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 17256598 N8399LSanders George W Jr · Cloverdale, INBuilt 1968 · S/N 17256599 N8400LInstant Print Signs & Designs LLC · Kalispell, MTBuilt 1968 · S/N 17256600

Back to Cessna 172I