Skip to content

Registered aircraft · 395

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

N101RKettunen Alan C · Ashtabula, OHBuilt 1946 · S/N 2125 N102MMZahler Mitchell J · Stillwater, MNS/N 71 N1043UClinton Arlys L · Fair Oaks, CABuilt 1946 · S/N 81 N10SSShepherd William S · Sequim, WABuilt 1946 · S/N 203 N1117RSchmidt Gail · Florence, COS/N 2008 N1122WWittman Dennis K · La Crescenta, CABuilt 1946 · S/N 1234 N11HFBell Michael S · Trinity, TXBuilt 1946 · S/N 1191 N121HPPk Flyer LLC · Lancaster, CABuilt 1956 · S/N 3643 N157TCBengtson Todd D · Tyler, TXBuilt 1946 · S/N 1101 N161SReliant Air LLC · Nashua, NHBuilt 1946 · S/N 1074 N17SYSeven Sierra Yankee LLC · Monroeville, PABuilt 1946 · S/N 1277 N191KBudd William M · St Simons Island, GABuilt 1946 · S/N 252 N20EMartin James P · Sioux City, IABuilt 1946 · S/N 1121 N210SXSims Stephen E · Locust Grove, GABuilt 1946 · S/N 394 N2115Welsh Christopher M · Oxford, NCS/N 1152 N212TTTaylor Thomas A · Littleriver, CABuilt 1946 · S/N 1206 N217LPSwift Museum Foundation · Athens, TNBuilt 1946 · S/N 310 N21FANikodem James · Crystal Lake, ILBuilt 1950 · S/N 3727 N2332BBartholomew Don B · Gardnerville, NVBuilt 1948 · S/N 3632 N2334BN2334b LLC · Omaha, NEBuilt 1948 · S/N 3634 N2361BCaudell Michael A · Cleveland, GABuilt 1948 · S/N 3661 N2365BKeller Baxter Benjamin · Madison, CTBuilt 1948 · S/N 3665 N2369BCc Motors LLC · Redding, CABuilt 1948 · S/N 3669 N2372BKing Larry Joe · Quanah, TXBuilt 1948 · S/N 3672 N2383BArt-Ticulate Tees LLC · Hazard, KYBuilt 1948 · S/N 3683 N2387BMacken Inc Corp · Saint Paul, MNBuilt 1948 · S/N 3687 N2394BSackett Dennis M · Orangevale, CABuilt 1948 · S/N 3694 N2403BDmm Airshows LLC · Wilmington, DEBuilt 1949 · S/N 3703 N2410BMiller Charles T · Bynum, TXBuilt 1949 · S/N 3710 N2432BKuffel Florian L · Seattle, WABuilt 1950 · S/N 3732 N2449BHolliday Mark E · Lake Elmo, MNBuilt 1950 · S/N 3749 N2453BWalker Ray · Sanger, TXS/N 3753 N24SEBertus David · Coppell, TXBuilt 1946 · S/N 2151 N266JTCochran Keith W · Long Beach, CAS/N 1154 N280VFKaczmarek Richard G · Sandersville, GABuilt 1946 · S/N 2260 N28AGZahler Mitchell J · Stillwater, MNBuilt 1946 · S/N 42 N2LMCollins Cody W · Palestine, TXS/N 2021 N30JWLittle Colin J · Bidwell, OHS/N 1022 N31WAbell Alan R · Elgin, ILBuilt 1946 · S/N 408 N3200KRock Jeffrey B · Fountain Valley, CABuilt 1946 · S/N 1193 N3202KKennelly Kevin T · Fort Lupton, COBuilt 1946 · S/N 1195 N3207KHull Bart D · Laveen, AZBuilt 1946 · S/N 1200 N3210KBurrous Peter M · Mount Pleasant, SCBuilt 1946 · S/N 1203 N3214KGadis Anthony J · Etiwanda, CABuilt 1946 · S/N 1207 N3224KBoronkay Peter H · Rockwall, TXBuilt 1946 · S/N 1217 N3230KMoore Michael C · Brooklyn, MIS/N 1223 N3232KEastern Stearman Inc Trustee · Leesburg, VABuilt 1946 · S/N 1225 N3235KRacoon Aviation LLC · San Antonio, TXBuilt 1946 · S/N 1228 N3240KJester Andrew R · Santa Claus, INBuilt 1946 · S/N 1233 N3242KPorter Thomas G · San Carlos, CABuilt 1946 · S/N 1235

Back to Globe GC-1B