Skip to content

Registered aircraft · 33

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

N10001Stoos Robert A · Lakeland, FLBuilt 1928 · S/N A28 N11253Patterson John Miles II · Frankfort, KYBuilt 1931 · S/N 3212 N119YLabarre John D · Cincinnati, OHBuilt 1930 · S/N 3220 N1826Bowe Walter C Trustee · Sonoma, CABuilt 1927 · S/N 914 N268MMorozowsky John S · Zanesville, OHBuilt 1929 · S/N DS3001 N4902Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1928 · S/N A2 N4WKreiter Kevin B · Camas, WAS/N X3101 N5020Bowe Walter C Trustee · Sonoma, CAS/N A-3 N5785Paul Richard · Fresno, CABuilt 1928 · S/N A-9 N604NHawk Aviation LLC · Springville, NYBuilt 1929 · S/N A-3107 N608NCyr Gregory A · Auburn, MEBuilt 1929 · S/N 3070 N625NHirtle Alan L · Oro Valley, AZS/N B-3145 N662NPinkerton Tim A · Trotwood, OHS/N C-3204 N662YCalvert Jared C · Ranger, TXS/N 3228 N6940Registered aircraftBuilt 1929 · S/N 3004 N699KHirtle Alan L · Oro Valley, AZS/N 70 N701ENurge Richard J · Gilroy, CAS/N 1942 N7091Embry Riddle Aeronautical University · Daytona Beach, FLBuilt 1928 · S/N A10 N709EBaker James L · Hallettsville, TXS/N A101 N763EHogan Thomas A · Fairfield, OHBuilt 1929 · S/N A-114 N766ERambo Gene · Falls Church, VAS/N A-120 N766KRadial Engines Ltd · Guthrie, OKS/N 823 N768KHone Ryan L · Dixie, IDBuilt 1929 · S/N A162 N775KCurry Steve C · Guthrie, OKS/N A-95 N8369Hirtle Alan L · Oro Valley, AZS/N A-73 N8540Hirtle Alan L · Oro Valley, AZS/N A-67 N931HOllmann Paul W · Poplar Grove, ILBuilt 1929 · S/N A143 N9500Dean James J · Sanford, NCBuilt 1928 · S/N 26 N9503C A S Aerobatic LLC · Carthage, MOBuilt 1928 · S/N 24 N9504Nichols Charles F Trustee · Baldwin Park, CAS/N 32 N9534Hirtle Alan L · Oro Valley, AZS/N A-29 N9538Hawk Aviation LLC · Springville, NYS/N A-37 N9541C A S Aerobatic LLC · Carthage, MOBuilt 1928 · S/N A-41

Back to Waco ASO