Skip to content

Registered aircraft · 34

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

N2130MMiles Donald · Columbia, MOBuilt 1946 · S/N 20916 N2176MFischer David K · Victor, NYBuilt 1946 · S/N 20964 N23240Langwell Mary K · Arroyo Grande, CABuilt 1939 · S/N 3006 N24721Gajewski Lillia M · Billings, MTBuilt 1939 · S/N 3394 N24759Lamb Daniel J · Onida, SDBuilt 1939 · S/N 3428 N25248Kratzman Kevin W · Fort Wayne, INS/N 7349 N25804Frazier Forrest Alan · Augusta, MOS/N 3755 N3068KRegistration Pending · Flower Mound, TXRegistration pendingBuilt 1946 · S/N 5048 N30846Otto Trever G · Verona, WIBuilt 1940 · S/N 5143 N31126Krug Gene G · Medford, WIBuilt 1940 · S/N 5346 N33010Thomson Kathryn Personal Representative · Lake Tapps, WABuilt 1940 · S/N 5769 N33160Husnik Brad M · Forest Lake, MNBuilt 1940 · S/N 5880 N33RQPhilyaw David A · Saint James, MOBuilt 1939 · S/N 3082 N35431Jankowski Philip J · Birchwood, WIBuilt 1941 · S/N 6337 N38449Woolslayer Joseph P · Tulsa, OKBuilt 1939 · S/N 7022 N38757Beinhauer Richard G · Naperville, ILS/N 7234 N41175Myers Randall · Parshall, NDBuilt 1941 · S/N 7813 N42083Olufsen Jane E · Lakeway, TXBuilt 1945 · S/N 14310 N42782Butcher Mike O · Big Lake, AKBuilt 1945 · S/N 15096 N42806Kent Gary W · Salome, AZBuilt 1945 · S/N 15121 N5496NWoelbing Aviation LLC · Franksville, WIBuilt 1944 · S/N 44-80782 N62941Meredith Dean J · Boynton Beach, FLS/N 8779 N6529HBennett Robert C · San Mateo, CABuilt 1946 · S/N 19718 N7004HFox Larry D · Hinton, WVBuilt 1946 · S/N 20249 N70281O'Brien Mark · Anchorage, KYBuilt 1946 · S/N 17262 N70375Hatbrightfarm LLC · Wilmington, DES/N 17361 N70510Albertson James M · Westville, FLBuilt 1946 · S/N 17516 N70793Sblendorio Thomas · Tequesta, FLS/N 17811 N7116HStarr Roger A Trustee · Canby, ORBuilt 1946 · S/N 20589 N77509Caraway Mike · Decatur, TXBuilt 1946 · S/N 22007 N88507Murdock Thomas L · Shawano, WIBuilt 1946 · S/N 16131 N92110Sims Christopher B · Marietta, GAS/N 16549 N98022Farmer Kenney · Milan, MIBuilt 1946 · S/N 18165 N98353Yellow Therapy LLC · Kalispell, MTBuilt 1946 · S/N 18523

Back to Piper J3C-85