Skip to content

Registered aircraft · 43

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

N74203Gray David M · Albuquerque, NMBuilt 1946 · S/N 1316 N74213Mullins Mike W · Marshall, TXBuilt 1946 · S/N 1326 N74228King John D · Midland, VABuilt 1946 · S/N 1341 N74231Valkyrie Wings LLC · Springville, UTBuilt 1946 · S/N 1344 N74233Hunter James Rogers · Schertz, TXBuilt 1946 · S/N 1346 N74241Hoover Ronald L · Springfield, MOS/N 1354 N74267Siler Martin R · Macon, GAS/N 1380 N74482Fox John E · Boonville, CABuilt 1948 · S/N 1595 N772Greene James H · Hosckton, GABuilt 1946 · S/N 1273 N77AYGould Russell Pearce · May, TXS/N 1156 N77HLBarton Bruce N · White Hills, AZS/N 1084 N86700Wahrer Terry J · Cripple Creek, COBuilt 1946 · S/N 1061 N86703Sale Reported · Chickasha, OKSale reportedBuilt 1946 · S/N 1064 N86719Holmberg Harold B · Stillwater, MNBuilt 1946 · S/N 1080 N86720Carpenter Teri R · Gearhart, ORS/N 1081 N86725Thoms Robert D · Clyde, MIS/N 1086 N86726Sale Reported · Mesa, AZSale reportedBuilt 1946 · S/N 1087 N86744Mcdonald Michael · Littlerock, CABuilt 1946 · S/N 1105 N86746Price Norman P · Live Oak, FLBuilt 1946 · S/N 1107 N86763Bagley Corydon R · South Jordan, UTBuilt 1946 · S/N 1124 N86771Seratt Timothy G · Harviell, MOBuilt 1946 · S/N 1132 N86786Goldschmidt Michael · Swanzey, NHBuilt 1946 · S/N 1147 N86787Olson Wesley M · Clovis, NMBuilt 1946 · S/N 1148 N86794Diamond Dale A · Tinton Falls, NJBuilt 1946 · S/N 1155 N86800Petik Neil L · Barney, NDBuilt 1946 · S/N 1161 N86806Officer Jarod P · Petaluma, CABuilt 1946 · S/N 1167 N86815Schnabel Albert Jr · Spencerport, NYBuilt 1946 · S/N 1176 N86831Kown William B · Hamilton, ALBuilt 1946 · S/N 1192 N86841Aero Legacy Foundation · Basehor, KSS/N 1202 N86851Nutter Michael S · University Place, WABuilt 1946 · S/N 1213 N86857Kimbrel Michael G · Oakville, WABuilt 1946 · S/N 1219 N86868Chisum Robert · Lorenzo, TXS/N 1230 N86875Hanson John G · Marion, MTS/N 1237 N86889Air Cargo & Taxi LLC · Prescott, AZBuilt 1946 · S/N 1251 N86897Chappel Steve · Stanwood, WABuilt 1946 · S/N 1259 N86909Dudnelly James · Oklahoma City, OKBuilt 1946 · S/N 1271 N86916Apogee Investments LLC · Grandview, TXBuilt 1946 · S/N 1278 N86920Cross Thomas W · Redding, CABuilt 1946 · S/N 1282 N86925Riley Samuel L · Harrison, ARS/N 1287 N86930Milwrick Donald D · Lincoln, MIBuilt 1946 · S/N 1292 N86937Ohlinger Mark A · Copley, OHBuilt 1946 · S/N 1299 N86944Franklin Gary Wayne · Lubbock, TXBuilt 1946 · S/N 1306 N86949Redtail Flyers Inc · Kalispell, MTBuilt 1946 · S/N 1210

Back to Bellanca 14-13