Skip to content

Registered aircraft · 45

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 ('7100610', '7104216')
  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 ('7100610', '7104216')
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.

N35428Reseigh Bracken John · Wasilla, AKBuilt 1941 · S/N 4-1388 N35598Lauterbach Paul D · Big Spring, TXS/N 4-1391 N35695Horovitz Paul M · Rincon, GABuilt 1941 · S/N 4-1400 N35698Sherlock Pete W · Gwinner, NDS/N 4-1397 N35729Wood Wesley W · Belle Fourche, SDBuilt 1941 · S/N 4-1407 N35814Cook Mike R · Rye, COS/N 4-1442 N35886Colvin Clu D DBA · Big Cabin, OKBuilt 1941 · S/N 4-1419 N35887Rose Carl Warren · Westmoreland, TNBuilt 1941 · S/N 4-1420 N35897Delavan Emery L Jr · Castroville, TXS/N 4-1427 N35901Wise Frederick W · Windsor, PABuilt 1941 · S/N 4-1432 N35903Colvin Clu D DBA · Big Cabin, OKBuilt 1941 · S/N 4-1431 N35906Geisler Mark C · Dallas, TXS/N 4-1436 N35908Ashley Edward A · San Antonio, TXBuilt 1941 · S/N 4-1438 N35916Lindenschmidt Robert J · Evansville, INBuilt 1955 · S/N 4-1445 N35920Strickland Thomas M · Akron, ALBuilt 1941 · S/N 4-1450 N35979Sword Scott B · Sublimity, ORBuilt 1941 · S/N 41459 N35984Cranford Billy J · Wasilla, AKBuilt 1941 · S/N 4-1465 N35985Cook Mike R · Rye, COS/N 4-1464 N35986Garst Charles L · Watson, MOBuilt 1941 · S/N 4-1468 N35988Lamb Ernest J · Catawba, NCBuilt 1941 · S/N 4-1471 N35991Cook Mike R · Rye, COBuilt 1941 · S/N 4-1478 N35992Price Joel A Trustee · Bozeman, MTBuilt 1941 · S/N 4-1474 N35999Kline Paul · Brooklyn, MIBuilt 1941 · S/N 4-1483 N37974Houston Dustin Lee · Wray, COBuilt 1941 · S/N 4-1505 N37982Mt Air LLC · Erie, COBuilt 1941 · S/N 4-1501 N37991Bayne Clyde O · Newcastle, WYBuilt 1941 · S/N 4-1485 N37994Fairbanks Kelly E · Twin Falls, IDBuilt 1941 · S/N 4-1490 N37996Birkhold Craig A · Napoleon, OHBuilt 1941 · S/N 4-1489 N38080Jenkins Michael D · Rigby, IDBuilt 1941 · S/N 4-1538 N38090Santerre Gary R · Baileyville, MEBuilt 1941 · S/N 4-1543 N38153Chapman Martin F · Bakersfield, CABuilt 1941 · S/N 41568 N38181Bayne Clyde O · Newcastle, WYS/N 4-1545 N38185Langston Scott R · Foxhome, MNBuilt 1941 · S/N 4-1551 N38187Stewart Thomas V · Churchville, NYBuilt 1941 · S/N 4-1552 N38196Brown Travis E · Leicester, NCBuilt 1941 · S/N 4-1566 N38880Shrader Sarah L · Rhinelander, WIBuilt 1941 · S/N 4-1595 N40696George Gary D · Humble, TXBuilt 1941 · S/N 4-1598 N40792Schulz Michael Alan · Upland, CABuilt 1941 · S/N 4-1602 N40988Barrientos Jeri D · Collinsville, OKBuilt 1941 · S/N 4-1610 N41058Waukecub Inc · Waukesha, WIBuilt 1941 · S/N 4-1621 N41065Kjeldgaard James K · Fremont, NEBuilt 1941 · S/N 4-1615 N41153Herren Roger L · Clayton, ILBuilt 1941 · S/N 4-1617 N41213Jenkins Michael D · Rigby, IDS/N 41636 N488XHSchulze Thomas A · Bloomville, OHS/N 4-1525 N56599Hetge Kenneth R · Tehachapi, CABuilt 1941 · S/N 4-1612

Back to Piper J4E