Skip to content

Registered aircraft · 61

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

N1601NStrahan Ronald R · Girard, KSBuilt 1946 · S/N 383 N1605NGraham Douglas R · Palmer, AKS/N 390 N1607NHuntley Lawrence H · Hernando, FLBuilt 1946 · S/N 392 N1608NKankakee Valley Aviation LLC · Wanatah, INBuilt 1946 · S/N 393 N1609NFunk Aeroplane Company · Basehor, KSBuilt 1946 · S/N 394 N1611NHistoric Aircraft Restoration Museum · Saint Louis, MOBuilt 1947 · S/N 411 N1612NHoffman Conrad · Madison, SDBuilt 1947 · S/N 410 N1613NSage Terry L · Tyler, TXBuilt 1947 · S/N 431 N1616NSaari Michael J · Sycamore, ILBuilt 1947 · S/N 402 N1617NTippit Larry J · Grand Prairie, TXS/N 403 N1626NHoward Kenneth L · Collinsville, OKS/N 406 N1632NVelemirov Michael L · Akron, OHBuilt 1947 · S/N 412 N1634NGooden John A · Tulsa, OKS/N 414 N1639NFrisby Craig · Rexburg, IDBuilt 1947 · S/N 419 N1642NJstream Lc · Sheridan, WYBuilt 1947 · S/N 422 N1644NNafziger Brian L Trustee · Cincinnati, OHBuilt 1947 · S/N 424 N1646NBlackmon Tommy J · Abilene, TXS/N 426 N1647NBeach Andrew N · Hawthorne, NVBuilt 1947 · S/N 427 N1650NSale Reported · La Plata, NMSale reportedBuilt 1947 · S/N 430 N1654NMaxfield John O · Canton, MIBuilt 1948 · S/N 438 N1655NScheufler Mark E · Seven Bays, WAS/N 439 N24134Airpower Museum Inc · Ottumwa, IABuilt 1940 · S/N 60 N24148Morozowsky Anthony M · Zanesville, OHBuilt 1940 · S/N 74 N24157Indy Air Sales LLC · Anderson, INBuilt 1940 · S/N 183 N2415ELaux Christopher B · Gladstone, MOBuilt 1939 · S/N 8 N332TSBeach Andrew W · Hawthorne, NVS/N 293 N41741Funk Aeroplane Company · Basehor, KSBuilt 1946 · S/N 223 N77705Anderson Dennis R · Brush Prairie, WABuilt 1946 · S/N 336 N77710Lugten Lyle · Hamilton, MIBuilt 1946 · S/N 380 N77715Masterson Fred A · Calera, ALBuilt 1946 · S/N 345 N77718Vyfvinkel Frederick J · New Smyrna Beach, FLS/N 348 N77720Jstream Lc · Sheridan, WYBuilt 1946 · S/N 350 N77721Cooper Walter O · Defiance, OHS/N 351 N77724Cochran Robert M · Marathon, NYS/N 354 N77725Mcdaniel Lee T · La Center, WABuilt 1946 · S/N 355 N77729Price John DBA · Bennington, KSBuilt 1946 · S/N 359 N77735Philbrick John F · Santa Margarita, CABuilt 1946 · S/N 365 N77738Haskin Justin Wade · Odessa, TXS/N 368 N77740Miller Barry W · Deltaville, VABuilt 1946 · S/N 370 N77742Brown Carl E · Greenville, TXBuilt 1946 · S/N 372 N77748Zumwalt B Joseph · Sheldon, ILBuilt 1946 · S/N 378 N81126White Jake W · San Antonio, TXBuilt 1946 · S/N 256 N81131Hamilton Dwight A · The Villages, FLBuilt 1946 · S/N 261 N81132Duffin James · Bonney Lake, WABuilt 1946 · S/N 262 N81134Gainsback Paul M · Mc Gaheysville, VABuilt 1946 · S/N 264 N81138Dexter Fred H · Live Oak, FLBuilt 1946 · S/N 268 N81139Riffle George W · Auburn, WABuilt 1948 · S/N 269 N81142Vanwagnen Karen S · Jackson, MIBuilt 1946 · S/N 272 N81143Jackson Thomas R Jr · Spearfish, SDS/N 273 N81148Morschauser Wade M · Fond Du Lac, WIS/N 278

Back to Funk B85C