Registered aircraft · 26

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

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 ('72202TG', '72202S9', '72202SL', '72202UC', '72202VU', '72202R7', '72202SE', '72202SJ', '72202SR', '72202ST', '72202SW', '72202SX', '72202TR', '72202TY', '72202UP', '72202UT', '72202VE', '72202VS', '72202VW', '72202VX', '72202R8', '72202R9', '72202RJ', '72202S1', '72202SF', '72202SH', '72202SM', '72202SN', '72202SZ', '72202TC', '72202TH', '72202TJ', '72202TW', '72202TX', '72202UM', '72202VP', '72202VZ') ORDER BY n_number

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 ('72202TG', '72202S9', '72202SL', '72202UC', '72202VU', '72202R7', '72202SE', '72202SJ', '72202SR', '72202ST', '72202SW', '72202SX', '72202TR', '72202TY', '72202UP', '72202UT', '72202VE', '72202VS', '72202VW', '72202VX', '72202R8', '72202R9', '72202RJ', '72202S1', '72202SF', '72202SH', '72202SM', '72202SN', '72202SZ', '72202TC', '72202TH', '72202TJ', '72202TW', '72202TX', '72202UM', '72202VP', '72202VZ')
  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 ('72202TG', '72202S9', '72202SL', '72202UC', '72202VU', '72202R7', '72202SE', '72202SJ', '72202SR', '72202ST', '72202SW', '72202SX', '72202TR', '72202TY', '72202UP', '72202UT', '72202VE', '72202VS', '72202VW', '72202VX', '72202R8', '72202R9', '72202RJ', '72202S1', '72202SF', '72202SH', '72202SM', '72202SN', '72202SZ', '72202TC', '72202TH', '72202TJ', '72202TW', '72202TX', '72202UM', '72202VP', '72202VZ')
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.

N11011Gilman Trevor J · North Adams, MABuilt 1968 · S/N 001 N116PMiller Robert J · Casselton, NDBuilt 1977 · S/N M79470 N11RGTurner William R · Dexter, MOBuilt 1972 · S/N 101 N120ESell Mark R · Woodbury, PABuilt 1965 · S/N 1 N12HGNaylor John H · Conway, ARS/N 1 N151RLinden Richard M Jr · Dallas, TXBuilt 1966 · S/N WA-1 N1581California Antique Aircraft Museum DBA · San Martin, CAS/N JD-1 N3100Meyer Matthew D · Redding, CABuilt 1967 · S/N 491421 N3117Daacke Edwards J · Glen Rock, PAS/N JJD-1 N32HHagaman John G Trustee · Alexandria, VABuilt 1967 · S/N 1512 N330MMHobbs Phillip E · Saint Augustine, FLBuilt 1983 · S/N 444 N39MRGraupman Gerald · Chicago, ILBuilt 1969 · S/N EGA-1 N4114Stauder Gregory P · Galena, ILBuilt 1968 · S/N 413 N4DStinson Brandon · Crowley, TXS/N JD1 N5191Murray Stewart · Capay, CABuilt 1968 · S/N 432 N593ASwift Harvey G · Clinton, ARBuilt 1968 · S/N S-512 N6431Cussen George J · Mount Prospect, ILBuilt 1971 · S/N 6431 N6435Weigle Timothy S · East Palestine, OHBuilt 1969 · S/N TS-1 N6610Seyour Lori L · Woodstock, GABuilt 1969 · S/N JSH-1 N6ZHarris Hayden H · Chelsea, MIBuilt 1980 · S/N JM-2 N7601URoads End Aero LLC · Erwinna, PABuilt 1968 · S/N 112 N8008AHolbrook Maslen · Caldwell, IDS/N 5932 N8128Kubichek Janet C · Winnemucca, NVBuilt 1968 · S/N AGE-140 N8318Rickey Donald Leslie · Murfreesboro, TNS/N 6223 N8LEverything Pitts LLC · Queen Creek, AZBuilt 1963 · S/N 11 N91TSTakacs Robert S · Oxford, CTS/N 101

Back to Pitts Special S-1C