Skip to content

Registered aircraft · 21

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

N1234CErickson Mark D · Valley Springs, SDBuilt 1937 · S/N 1697 N14419Pietsch Warren A · Minot, NDBuilt 1937 · S/N 1607 N16360Dean James J · Sanford, NCBuilt 1943 · S/N 589 N16667Stewart Mark W · Arnold, MDBuilt 1936 · S/N 682 N16743Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 580 N16745Machamer John K · Gettysburg, PABuilt 1936 · S/N 747 N16747Curtis Air · Pittsfield, MEBuilt 1936 · S/N 749 N16947Tre Aviation Corp · Wilmington, DEBuilt 1936 · S/N 813 N16957Hurlburt Ronald V DBA · Durand, WIBuilt 1936 · S/N 823 N16997Womack Cameron M · Jackson, LAS/N 863 N17216Morgan Dale C · Mc Calla, ALS/N 882 N17240Brandt Terry R · Hood River, ORS/N 906 N17253Command Aire LLC · Sitka, AKBuilt 1936 · S/N 919 N17261Schaller Lee W · New Athens, ILBuilt 1936 · S/N 927 N17284Ficklin Robert L · Fairbury, ILBuilt 1936 · S/N 951 N17525Schulz Michael L · Norfolk, NEBuilt 1936 · S/N 945 N19252Kretsinger Steven H Trustee · Eugene, ORBuilt 1937 · S/N 1652 N19512Salvador Ricky M · San Marcos, CABuilt 1937 · S/N 1712 N19563Registered aircraftS/N 1763 N20027Edmiston Brandon L · Murray, KYBuilt 1937 · S/N 1827 N20034Aas LLC · Ovid, MIBuilt 1937 · S/N 1834

Back to Taylor J-2