Skip to content

Registered aircraft · 435

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

N1171BWarganich Daniel J · Placerville, CABuilt 1960 · S/N 47675 N142HBonser Thomas A · Cincinnati, OHBuilt 1960 · S/N 47245 N172LRDevillers Daniel R · Kalamazoo, MIBuilt 1960 · S/N 47607 N172RMorales Jeremy · Brewster, NYBuilt 1961 · S/N 47349 N172XXRoberts Christopher B · Warner Robins, GAS/N 47123 N1AXEdgerton Agency Inc · Galena, OHBuilt 1960 · S/N 47418 N271REEigsti Rodney E Trustee · Friend, NEBuilt 1960 · S/N 47227 N333KVScearce Richard D · Mount Vernon, IABuilt 1959 · S/N 46990 N336DDNewman Christopher J · Lorena, TXBuilt 1960 · S/N 47254 N34264Aikens George A · Greeley, COBuilt 1959 · S/N 625 N3950RJung Christopher M · Anchorage, AKS/N 47424 N444TF4tf LLC · Missoula, MTBuilt 1959 · S/N 46907 N47559Valiair Lc Trustee · Casper, WYBuilt 1960 · S/N 47559 N511EZiese And Grieshaber Consulting LLC · Catawba, NCBuilt 1959 · S/N 47107 N6761TMccarville Katherine A · Fayette, IABuilt 1960 · S/N 47261 N6800XNew Vision Aviation Inc · Fresno, CABuilt 1960 · S/N 47700 N6803XDavis Joseph S · Andalusia, ALBuilt 1960 · S/N 47703 N6804XSusanville Aviatiors Inc · Susanville, CABuilt 1960 · S/N 47704 N6810XIdaho Flyers LLC · Buhl, IDBuilt 1960 · S/N 47710 N6812XBig Sky Aviation Inc · Wilmington, DEBuilt 1960 · S/N 47712 N6821XTudorani Vincenzo C · Las Vegas, NVS/N 47721 N6823XTipton Wendell D · Anchorage, AKBuilt 1960 · S/N 47723 N6827XCalderon Daniel C · Castro Valley, CABuilt 1960 · S/N 47727 N6829XZeegers Jozef · Bellingham, WABuilt 1960 · S/N 47729 N6832XOwens Philip A · Maryville, TNBuilt 1960 · S/N 47732 N6836XNelson John D · Sonora, CABuilt 1960 · S/N 47736 N6839XCripe Rodney J · Middlebury, INBuilt 1960 · S/N 47739 N6840XDesertshot Inc · El Paso, TXBuilt 1960 · S/N 47740 N6841XNelson Ricky R W · Mandan, NDS/N 47741 N6843XBoone Alan · Bangor, MEBuilt 1960 · S/N 47743 N7155TSw Idaho Flying Cooperative LLC · Boise, IDBuilt 1960 · S/N 46755 N7161TKoutsos Theodore J · New Port Richey, FLBuilt 1959 · S/N 46761 N7162TOyler Byron L · Converse, TXBuilt 1959 · S/N 46762 N7163TPeoble Douglas M · Tucson, AZS/N 46763 N7164TT Aviation Services Inc · Canovanas, PRBuilt 1959 · S/N 46764 N7166TCentral Aviation LLC · White City, ORBuilt 1959 · S/N 46766 N7169TBrent Ephron D · Arriba, COBuilt 1959 · S/N 46769 N7173TDidier Thomas · Port Washington, WIS/N 46773 N7174TPaddock Spencer · Palmer, AKBuilt 1960 · S/N 46774 N7175TTischer William D · Shoreview, MNBuilt 1959 · S/N 46775 N7176TRabe Robert · Elk Grove, CAS/N 46776 N7177TLefevers Adam · Pineville, KYS/N 46777 N7178TGouin Cristina Clara · Fort Pierce, FLBuilt 1959 · S/N 46778 N7181TSwanson G N · Meridian, IDBuilt 1959 · S/N 46781 N7182TTdp LLC · Caldwell, IDBuilt 1959 · S/N 46782 N7184THelderman Laban W · Newton, NCS/N 46784 N7191TLawson Isaiah · Roswell, NMBuilt 1959 · S/N 46791 N7193TJones Wade T · Wichita, KSBuilt 1959 · S/N 46793 N7194THall William A · Puyallup, WAS/N 46794 N7197TNelson Jim · Midlothian, TXS/N 46797

Back to Cessna 172A