Skip to content

Registered aircraft · 115

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

N11LSSmall Robert Lance · Fredericksburg, TXBuilt 1946 · S/N 1296 N1CYSwift Museum Foundation Inc · Athens, TNBuilt 1948 · S/N 3572 N22GWSchneider Dan · Lusby, MDBuilt 1949 · S/N 3726 N2300BGoodox LLC · Garden Plain, KSBuilt 1948 · S/N 3600 N2301BKing Larry Joe · Quanah, TXBuilt 1948 · S/N 3601 N2305BDoyal William T · Visalia, CAS/N 3605 N2306BBandrowicz Leon A · Lindenhurst, NYBuilt 1948 · S/N 3606 N2307BMoyer Alan L · Perkasie, PABuilt 1948 · S/N 3607 N2313BVanreeth Edward D · Huntley, ILBuilt 1948 · S/N 3613 N2319BGidzinski Daniel P · Campbellsburg, KYBuilt 1948 · S/N 3619 N2320BKuffel Florian L · Seattle, WABuilt 1948 · S/N 3620 N2328BAaron Richard · Sussex, NJBuilt 1948 · S/N 3628 N2329BCarpino Kevin · Gretna, NEBuilt 1948 · S/N 3629 N2330BPeck John A Jr · Shady Shores, TXS/N 3630 N2335BBradley Gary C · Orchard Park, NYBuilt 1948 · S/N 3635 N2336BGibbs Dana Trustee · Arlington, TXBuilt 1948 · S/N 3636 N2337BJohnson John Jay · Wasilla, AKBuilt 1978 · S/N 3637 N2339BSwanson Gregory R · Huntsville, ALBuilt 1948 · S/N 3639 N2349BSwift Museum Foundation Inc · Athens, TNBuilt 1948 · S/N 3649 N2350BWhitmore Joel P · Mesquite, NVBuilt 1948 · S/N 3650 N2356BHall Noel W · Pinecliffe, COBuilt 1948 · S/N 3656 N2360BWilfong David C · Warrenton, VAS/N 3660 N2362BGist Jimmy L · Horseshoe Bay, TXBuilt 1948 · S/N 3662 N2367BZahler Mitchell J · Stillwater, MNBuilt 1948 · S/N 3667 N2373BWarbird Adventures Inc · Ocoee, FLBuilt 1948 · S/N 3673 N2374BBoard David N · Moundsville, WVBuilt 1948 · S/N 3674 N2379BRegistered aircraftBuilt 1948 · S/N 3679 N2384BAuiler Casey · San Diego, CABuilt 1948 · S/N 3684 N2385BHernandez Dominic Juan · Brighton, COBuilt 1948 · S/N 3685 N2390BSwift Museum Foundation Inc · Athens, TNS/N 3690 N2397BCochran Keith · Long Beach, CAS/N 3697 N2398BCross John P · Houston, TXBuilt 1949 · S/N 3698 N2399BSummerland Spins LLC · Summerland Key, FLBuilt 1948 · S/N 3699 N2402BDaulton Rodney D · New Port Richey, FLBuilt 1949 · S/N 3702 N2404BHaugen Michael · Oklahoma City, OKBuilt 1949 · S/N 3704 N2413BLohse Randy · Onalaska, WABuilt 1949 · S/N 3713 N2418BBartholomew Don B · Gardnerville, NVS/N 3718 N2419BFenn Michael J · Cloverdale, CAS/N 3719 N2422BRoki Classics LLC · Ogallala, NEBuilt 1949 · S/N 3722 N2428BZahler Mitchell J · Stillwater, MNBuilt 1949 · S/N 3728 N2429BRegistration Pending · Oshkosh, WIRegistration pendingBuilt 1950 · S/N 3729 N2431BSampson Joel L · Belview, MNBuilt 1950 · S/N 3731 N2436BDahler George F · Monterey, CABuilt 1950 · S/N 3736 N2437BHernandez Dominic J · Brighton, COS/N 3739 N2438BJentes Charles A · Smithville, OHS/N 3738 N2440BBrubaker Farm Company Inc · Traer, IABuilt 1950 · S/N 3740 N2441BNaumann Scott Trustee · Arroyo Grande, CABuilt 1950 · S/N 3741 N2442BSwifty LLC · Dover, DES/N 3742 N2443BBartholomew Don · Gardnerville, NVBuilt 1950 · S/N 3743 N2444BRubiano Anthony · Cheyenne, WYBuilt 1950 · S/N 3744

Back to Temco GC-1B