Skip to content

Registered aircraft · 122

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

N10198Coonfield Russell A · Fayetteville, ARS/N 603 N12CXHinds Bruce R · Port Orchard, WABuilt 1947 · S/N 264 N12XEMacleod Edward N · Trenton, MEBuilt 1947 · S/N 1059 N191VMcgregor Carter III · Wichita Falls, TXBuilt 1946 · S/N 150 N20CBHayes Jack D · Kingman, AZBuilt 1947 · S/N 522 N217GHoag Tom E · Bellevue, WABuilt 1947 · S/N 797 N230FKings Wings LLC · Elkton, VAS/N 519 N27CBHuey Andrew G · Fulton, MOBuilt 1947 · S/N 262 N295CBMurphy Patrick W · Orange City, FLBuilt 1947 · S/N 912 N2TBWhalen Shenandoah · Amelia, OHBuilt 1947 · S/N 819 N3263GMadden Russell · Graford, TXBuilt 1947 · S/N 361 N328CBThorne Matthew L · Vicksburg, MIS/N 940 N33CSMtas LLC · Laveen, AZS/N 994 N451EMensing Roger G · Sarasota, FLBuilt 1946 · S/N 182 N451ZAlquist Kevin B · Edwardsville, KSBuilt 1947 · S/N 584 N463RKKaskel Super Service LLC · Evansville, INBuilt 1947 · S/N 958 N5090JAttitude Toys LLC · Wilmington, DEBuilt 1946 · S/N 244 N5166BHublou Frank E · Carson City, NVBuilt 1947 · S/N 1000 N5989MJohnson Dean M · Hamden, CTBuilt 1947 · S/N 387 N5YLBold William H Jr · Annapolis, MDBuilt 1947 · S/N 330 N6007KPark Richard A · Alameda, CABuilt 1946 · S/N 177 N6041KLudmerer Victor J · Greenwood Lake, NYBuilt 1946 · S/N 216 N6047KMummy Mountain Med LLC · Paradise Valley, AZS/N 222 N6048KWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1947 · S/N 223 N6072KWeiss Elliott · Fresno, TXBuilt 1947 · S/N 252 N6102KSes Bee LLC · Appleton, WIBuilt 1947 · S/N 285 N6113KRegistered aircraftS/N 296 N6118KAllen Richard P · Southampton, NJBuilt 1947 · S/N 301 N6124KLacy Clay Trustee · Los Angeles, CAS/N 310 N6138KBassett Douglas C · Long Lake, NYBuilt 1947 · S/N 324 N6175KOptimus Aircraft Service Inc · Middletown, DEBuilt 1947 · S/N 363 N6190KMampel Gregory John · New Port Richey, FLBuilt 1947 · S/N 381 N6201KLawson William E · Somerset, WIBuilt 1947 · S/N 397 N6204KPvb36 Leasing LLC · Denton, TXBuilt 1947 · S/N 404 N6208KBishop Bruce L · Durango, COBuilt 1947 · S/N 408 N6209KNobleartaviation Inc Trustee · Wilmington, DEBuilt 1947 · S/N 409 N6210KPorter Gary O · Oregonia, OHS/N 413 N6222KBromschwig Kurt F Trustee · Montgomery, TXBuilt 1947 · S/N 425 N6224KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 430 N6230KCuny John B · Carlsborg, WABuilt 1947 · S/N 433 N6232KCoutches Robert H · Livermore, CABuilt 1947 · S/N 435 N6234KNab Air LLC · Idaho Springs, COBuilt 1947 · S/N 437 N6239KVrechek Joseph D · Fort Lauderdale, FLS/N 442 N6240KJanus William Walter · Belchertown, MABuilt 1947 · S/N 443 N62544Brown George H · Youngstown, NYBuilt 1947 · S/N 464 N6267KMill Boys Flying LLC · Wilmington, DES/N 477 N6272KWoodberry Robert · Mineral, VABuilt 1946 · S/N 482 N6283KTraylor Robert B · Millersview, TXBuilt 1947 · S/N 496 N6286KKomko Randy M · Mckenna, WAS/N 499 N6288CSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 441

Back to Republic RC-3