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.

N8401LBlack Baron Air LLC · Kalispell, MTS/N 17256601 N8402LVan Bortel Inc · Victor, NYBuilt 1968 · S/N 17256602 N8406LVee Neal Aviation · Latrobe, PABuilt 1968 · S/N 17256606 N8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIBuilt 1968 · S/N 17256607 N8409LRegistered aircraftBuilt 1968 · S/N 17256609 N8410LVictory Lane Aviation LLC · Concord, NCBuilt 1968 · S/N 17256610 N8412LAddison Flying LLC · Addison, NYBuilt 1968 · S/N 17256612 N8413LRussell Adam G · Easton, MES/N 17256613 N8414LMorris Christopher J · Manor, TXBuilt 1968 · S/N 17256614 N841JARicci Theodore J · Spotswood, NJBuilt 1968 · S/N 17256902 N8420LHayhurst Shane R · Winfield, PABuilt 1968 · S/N 17256620 N8422LHubert Kim J Trustee · Eagle River, AKBuilt 1968 · S/N 17256622 N8423LYoung James A · Toledo, WAS/N 17256623 N8424LMcgreen John R · Albany, NYBuilt 1968 · S/N 17256624 N8431LDsr Cherokee 180 LLC · Dallas, TXS/N 17256631 N8432LAster Labs Inc · Shoreview, MNBuilt 1968 · S/N 17256632 N8433LHeacock Jeffrey A · Hollis, MEBuilt 1968 · S/N 17256633 N8434LMemmi Charles D · Three Springs, PABuilt 1968 · S/N 17256634 N8435LAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1968 · S/N 17256635 N8440LRoot William L Trustee · Scotia, NEBuilt 1968 · S/N 17256640 N8441LG1 Aviation LLC · Ocala, FLBuilt 1968 · S/N 17256641 N8444LRiley David R · Baltimore, MDBuilt 1968 · S/N 17256644 N8445LCurtis Bruce G · Eugene, ORBuilt 1968 · S/N 17256645 N8450LElghammer Garrott W · Niles, MIBuilt 1968 · S/N 17256650 N8452LParr Terri M · Catlin, ILBuilt 1968 · S/N 17256652 N8455LYoumans Ronald E · Baxley, GABuilt 1968 · S/N 17256655 N8456LCherryhill Aviation Inc · Freetown, INBuilt 1968 · S/N 17256656 N8458LLeap And Bound Child Dev Ctr LLC · Redondo Beach, CAFirst renewal noticeBuilt 1968 · S/N 17256658 N8459LBelcher Otha A · Centreville, ALBuilt 1968 · S/N 17256659 N8461LScott Gerald D · Fieldon, ILBuilt 1968 · S/N 17256661 N8463LWings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17256663 N8466LWild Blue Yonder LLC · Lewes, DES/N 17256666 N8468LMidstate Aviation 1 LLC · Owosso, MIBuilt 1968 · S/N 17256668 N8469LZitko Philip R · Shelby, OHBuilt 1968 · S/N 17256669 N8476LHeusinkveld Kevin D · Christiana, TNBuilt 1968 · S/N 17256676 N8477LKulm Aviation LLC · Kulm, NDBuilt 1968 · S/N 17256677 N8479LBurton Nathan · Warsaw, MOBuilt 1968 · S/N 17256679 N8480LMiss Rebecka LLC · Hancock, MEBuilt 1968 · S/N 17256680 N8483LChickasha Wings Inc · Chickasha, OKBuilt 1968 · S/N 17256683 N8486LPockevich Dave A · Palmer, AKBuilt 1968 · S/N 17256686 N8488LHarrier Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N 17256688 N8489LBarlow Warren P · Madison, ALBuilt 1968 · S/N 17256689 N8490LMgg Aviation 2025 LLC · Annandale, MNBuilt 1968 · S/N 17256690 N8491LDeb Air Inc · Norcross, GABuilt 1968 · S/N 17256691 N8492LCarey Thomas A · Carabaset Vly, MEBuilt 1968 · S/N 17256692 N8493LBriss David S Dmd · Somerset, NJBuilt 1968 · S/N 17256693 N8494LHess Garrett · Fullerton, CABuilt 1968 · S/N 17256694 N8498LWestern Slope Aviators LLC · Delta, COBuilt 1968 · S/N 17256698 N8499LKennedy Christopher S · Canton, ILBuilt 1968 · S/N 17256699 N894Blanton Aircraft Co Inc · Orlando, FLFirst renewal noticeBuilt 1968 · S/N 17257119

Back to Cessna 172I