Registered aircraft · 19

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

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 ('83501K9', '835010A', '835010D', '835010U', '835010Z', '83501L5', '83501LD', '83501LV', '83501N7', '83501S1', '83501SV', '83501V4', '83501VD', '83501VG', '83501VP', '83501XJ', '83501YM', '83501Z3', '835010P', '835010R', '83501LK', '83501LW', '83501M1', '83501MF', '83501MR', '83501NX', '83501P3', '83501Q4', '83501Q9', '83501QD', '83501QJ', '83501QP', '83501RP', '83501RV', '83501RX', '83501RY', '83501S3', '83501SF', '83501SR', '83501ST', '83501T7', '83501TB', '83501U8', '83501UH', '83501UT', '83501UZ', '83501V9', '83501VJ', '83501VZ', '83501W5', '83501WK', '83501WV', '83501X1', '83501X4', '83501XM', '83501YB', '83501YS', '83501ZA', '83501ZH', '83501ZT') ORDER BY n_number

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 ('83501K9', '835010A', '835010D', '835010U', '835010Z', '83501L5', '83501LD', '83501LV', '83501N7', '83501S1', '83501SV', '83501V4', '83501VD', '83501VG', '83501VP', '83501XJ', '83501YM', '83501Z3', '835010P', '835010R', '83501LK', '83501LW', '83501M1', '83501MF', '83501MR', '83501NX', '83501P3', '83501Q4', '83501Q9', '83501QD', '83501QJ', '83501QP', '83501RP', '83501RV', '83501RX', '83501RY', '83501S3', '83501SF', '83501SR', '83501ST', '83501T7', '83501TB', '83501U8', '83501UH', '83501UT', '83501UZ', '83501V9', '83501VJ', '83501VZ', '83501W5', '83501WK', '83501WV', '83501X1', '83501X4', '83501XM', '83501YB', '83501YS', '83501ZA', '83501ZH', '83501ZT')
  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 ('83501K9', '835010A', '835010D', '835010U', '835010Z', '83501L5', '83501LD', '83501LV', '83501N7', '83501S1', '83501SV', '83501V4', '83501VD', '83501VG', '83501VP', '83501XJ', '83501YM', '83501Z3', '835010P', '835010R', '83501LK', '83501LW', '83501M1', '83501MF', '83501MR', '83501NX', '83501P3', '83501Q4', '83501Q9', '83501QD', '83501QJ', '83501QP', '83501RP', '83501RV', '83501RX', '83501RY', '83501S3', '83501SF', '83501SR', '83501ST', '83501T7', '83501TB', '83501U8', '83501UH', '83501UT', '83501UZ', '83501V9', '83501VJ', '83501VZ', '83501W5', '83501WK', '83501WV', '83501X1', '83501X4', '83501XM', '83501YB', '83501YS', '83501ZA', '83501ZH', '83501ZT')
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.

N1475Magee Richard A · Virden, ILBuilt 1970 · S/N 41 N147HLeroy Philippe G · Willcox, AZBuilt 1964 · S/N DH41 N1711Burgess Mark W · Greene, MES/N 1 N179VPBas Part Sales LLC · Greeley, COS/N 1 N25PWilliamson Tracy C · Texarkana, TXS/N HCP-2 N341SRebr Holdings LLC · Hernando, FLS/N 1939 N391YBall Charles D · Ocala, FLBuilt 1965 · S/N 1 N3986Harter James A · Centerville, OHBuilt 1975 · S/N OBT-1 N4756GOliver Randy M · Limerick, MEBuilt 1973 · S/N G-1 N4843Burke Timothy E · Temple, TXS/N RWW-1 N5166Becker James J · Oconomowoc, WIBuilt 1969 · S/N JB-1 N5167Bares Maurice G · Youngsville, LABuilt 1970 · S/N DSA-1-100 N558AGalindo Don R Jr · Walnut Grove, CABuilt 1963 · S/N SL-1 N559AStewart Emmerson C Jr · Waynesville, OHBuilt 1963 · S/N FD-1 N791JWilson Cliff · Harrison, IDS/N 633747 N79EHeyrman Larry L · New Franken, WIBuilt 1963 · S/N ABEE-1 N7JHHultsch Kevin · Lockport, ILBuilt 1978 · S/N JH-1 N91271Morrow David R · Maynardville, TNBuilt 1965 · S/N BF1001 N931ZMason Fred B · Waterford, OHBuilt 1968 · S/N SE-1

Back to Smith Miniplane DSA-1