Skip to content

Registered aircraft · 27

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

N2225MBerry Darrel · Camden, TNBuilt 1946 · S/N 21017 N23409Miller Harrison · Hallsville, MOS/N 3144 N25730Orton Aviation LLC · Walker, MNBuilt 1940 · S/N 3690 N30766Scotton Bradley D · Galena, AKBuilt 1940 · S/N 5098 N32673Autry Lonnie E · San Jose, CABuilt 1940 · S/N 5532 N32955Finn Kathryn L K · Grand Marais, MNS/N 5739 N3316NBender Dennis R · Johnson, VTBuilt 1946 · S/N 22515 N35499Turner David · Frenchtown, NJBuilt 1941 · S/N 6404 N3574WOrton Aviation LLC · Walker, MNBuilt 1946 · S/N 18159 N3613KSorenson Kenneth G · Waller, TXBuilt 1946 · S/N 22301 N42644Wingnut Inc · Wilmington, DEBuilt 1945 · S/N 14935 N49500Chain Steven R · Cottonwood, CABuilt 1942 · S/N G-3 N70272Roussopoulos Gary L · Santa Cruz, CABuilt 1946 · S/N 17253 N70274Two Rays LLC · Charleston, MSBuilt 1941 · S/N 17255 N70661Reed Conrad H · Centre, ALS/N 17681 N70897International Air Services Inc Trustee · Carson City, NVS/N 17984 N70914Schumacher Bradley R · Elma, NYBuilt 1946 · S/N 17934 N71014Hofmann John M · Columbus, WIBuilt 1946 · S/N 18030 N88151Waterlanding LLC · Missoula, MTBuilt 1946 · S/N 15768 N91943Clark Henry F Jr · Fort Edward, NYBuilt 1946 · S/N 16363 N92044Lear Eric T · Tomahawk, WIBuilt 1946 · S/N 16477 N92167Yedowitz Michael C · New Milford, CTS/N 16699 N92620Goodrich Jeffrey W · Slaton, TXBuilt 1946 · S/N 16983 N98701Fandler Frederick E · Denton, TXBuilt 1946 · S/N 18931 N98729Aviation Consultants Inc · Newton, NJS/N 18957 N98762Fowler Matthew S · Austin, TXBuilt 1946 · S/N 18995 N98864Williams Francis B III · Meridian, GABuilt 1946 · S/N 19126

Back to Piper J3C-65S