Skip to content

Mcclish FUNK B85C

Registered aircraft · 27

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

N1603NEaves Donald R · Byhalia, MSBuilt 1946 · S/N 385 N1625NSowell Thomas A · Port Orange, FLBuilt 1947 · S/N 405 N1630NNewton Zachary · Bowling Green, KYBuilt 1948 · S/N 398 N1640NBurger Terry L Trustee · Salina, KSBuilt 1947 · S/N 420 N1648NPrice John DBA · Bennington, KSBuilt 1947 · S/N 428 N22686Tucker Lon R · East Peoria, ILBuilt 1939 · S/N 13 N24109Bird Karl N · Wasilla, AKBuilt 1940 · S/N 34 N24120Hamilton Dwight A · Wildwood, FLBuilt 1940 · S/N 46 N77701Dates Alec E · Red Creek, NYBuilt 1946 · S/N 331 N77707Funk Aeroplane Co · Basehor, KSBuilt 1946 · S/N 337 N77708Arizona Bravo Lima LLC · Phoenix, AZBuilt 1946 · S/N 338 N77712Texas Air Museum · San Antonio, TXBuilt 1946 · S/N 342 N77714Hurt Roy A DBA · Newark, OHBuilt 1946 · S/N 344 N77719Tundra Aviation Inc · Casselton, NDBuilt 1946 · S/N 349 N77722Jstream Lc · Sheridan, WYBuilt 1946 · S/N 352 N77731Dawson Harry E Jr · Rome, GABuilt 1946 · S/N 361 N77732Specht Leo M · Towner, COBuilt 1946 · S/N 362 N77736Riffle George W · Auburn, WABuilt 1946 · S/N 366 N77741Wirt Christopher W · Chehalis, WABuilt 1946 · S/N 371 N81123Em Flight Services LLC · Homestead, FLBuilt 1946 · S/N 253 N81130Skoog Gerald D · Greencastle, INBuilt 1946 · S/N 260 N81135Wang Grace H · Mojave, CABuilt 1946 · S/N 265 N81136Pearlman Aircraft Co · Orlando, FLBuilt 1946 · S/N 266 N81137Ozarks Auto Show Inc · Hollister, MOBuilt 1946 · S/N 267 N81160Tharpe George W · Street, MDBuilt 1946 · S/N 290 N81180Williams Ryan P · Durant, OKBuilt 1946 · S/N 310 N81190Achterman Ernest F · Cochranton, PABuilt 1946 · S/N 320

Back to Mcclish FUNK B85C