Skip to content

Registered aircraft · 660

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

N72457Reavis John F · Harmony, NCBuilt 1946 · S/N 9622 N72482Martin Peter · Seattle, WABuilt 1946 · S/N 9650 N72496Cannon Daniel T · San Diego, CABuilt 1946 · S/N 9666 N72512Jeffrey Mark D · Clayton, MIS/N 9682 N72516Schwalm Wylie H · Spearfish, SDBuilt 1946 · S/N 9686 N72536Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1946 · S/N 9706 N72540Thomas Robert S · San Diego, CABuilt 1946 · S/N 9710 N72544Fontenot Rickey D · Ville Platte, LABuilt 1946 · S/N 9714 N72548Bronge Adam M · Ballwin, MOBuilt 1946 · S/N 9718 N72552Johnson Aviation & Restoration LLC · Jacksonville, FLS/N 9722 N72556Mccutcheon Claude C · Fort Worth, TXBuilt 1946 · S/N 9726 N72560Jerkins Marvin Q · Coffee Springs, ALS/N 9730 N72564Hallett Mark R · Hobe Sound, FLBuilt 1946 · S/N 9734 N72568Miller Alan K · Scotia, NYBuilt 1946 · S/N 9738 N72572Barnes Brett · Jacksonville, FLBuilt 1946 · S/N 9742 N72610Hupert Jason M · Grand Blanc, MIBuilt 1946 · S/N 9786 N72622Crewdson Christopher · Forest Grove, ORS/N 9798 N72650Mecham Gerald W Jr · Mesa, AZBuilt 1946 · S/N 9826 N72654Benson Lawrence E Jr · Peru, INBuilt 1946 · S/N 9830 N72674Beech O Sphere LLC · Casper, WYBuilt 1946 · S/N 9850 N72682Sides Gregory L · Dry Fork, VABuilt 1946 · S/N 9858 N72715Ursitti James III · Beaver, PABuilt 1946 · S/N 9894 N72719Longino Justin E · Troutman, NCBuilt 1946 · S/N 9898 N72739Blythe Anne T · Paso Robles, CABuilt 1946 · S/N 9918 N72747Blades Audie · Newman, CABuilt 1946 · S/N 9930 N72759Casey Joseph C · Jacksonville, TXFirst renewal noticeS/N 9942 N72775Strode Lawrence W · Naknek, AKBuilt 1946 · S/N 9958 N72800Roberts Donald W · Valley Grande, ALBuilt 1946 · S/N 9986 N72804Covenant Security Svcs Psp · Decatur, TXBuilt 1946 · S/N 9990 N72808Cutter Anthony · Corning, CABuilt 1946 · S/N 9994 N72812Wooley Michael W · Navarre, FLBuilt 1946 · S/N 9998 N72851Milton William H · Amsterdam, NYBuilt 1946 · S/N 10038 N72863Escovedo Ricky L · Oroville, CAS/N 10054 N72867Vega Abraham · Del Rio, TXBuilt 1946 · S/N 10058 N72900Guske Brad H · Montrose, CAS/N 10094 N72904Bryan Andrew R · Eureka, CABuilt 1946 · S/N 10098 N72908Pate Charles C Trustee · Wichita, KSBuilt 1946 · S/N 10102 N72932Healis William J · Scottsdale, AZS/N 10130 N72944Dirigo Aerospace Solutions LLC · Sumner, MEBuilt 1946 · S/N 10142 N72977Parish Gary R · Olive Branch, MSS/N 10178 N72981Knight Andrew J · Wasilla, AKBuilt 1946 · S/N 10182 N72989Meier Perry S · Conroe, TXS/N 10194 N72997Faust Charles B · Long Prairie, MNBuilt 1946 · S/N 10202 N73009Davenport Ross K · Raleigh, NCBuilt 1946 · S/N 10214 N73021Wall David K · Ocala, FLBuilt 1946 · S/N 10226 N73029Riley Gary L · Prescott Valley, AZBuilt 1946 · S/N 10234 N73034Mueller Gary L · Eagle River, WIBuilt 1946 · S/N 10242 N73046Sutton Aircraft Salvage LLC · Palmer, AKS/N 10254 N73066Registered aircraftBuilt 1946 · S/N 10278 N73086Mayo William J Jr · Reed Point, MTBuilt 1946 · S/N 10302

Back to Cessna 120