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 ('7100510')
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 ('7100510')
ORDER BY n_numberRun 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.
N2020MBusque Michael J · Palmyra, MEN2022MRegistration Pending · Middletown, DERegistration pendingN2023MWild Gerry R · Lehighton, PAN20255Western Antique Aeroplane & Automobile Museum · Hood River, ORN2026MThompson Dan L · Paris, KYN2028MMiller Joseph H · Winston Salem, NCN202JLLosner Jeffrey D · Homestead, FLN2032ANighthawk Air Systems Inc · Miami, FLN2035MBowe Joseph E · Chippewa Falls, WIN2038MPiper Aviation Museum · Lock Haven, PAN2039MGeissler Henry · Webster, MNN2040MWest Lowell A · Mocksville, NCN2046MSmith Christopher N · Kitty Hawk, NCN2049MLittle Yellow Plane LLC · Wilmington, DEN2053MVan Houten James M · Alachua, FLN2058MStrutzenberg Keith W Trustee · Chandler, AZN2059MZimmerman John R · Bellefonte, PAN2063MDemo Salvage Inc · Calais, MEN2066MJones John E Jr · Metter, GAN2068MButler Steve L · Sioux City, IAN2075MRegistration Pending · Loveland, OHRegistration pendingN2081MReigle Aviation South LLC · Orlando, FLN2082MBurkholder Ruel J · Linville, VAN2083AEmmons John K · Corona, CAN2084LThomason James H III · New Smyrna Beach, FLN20886Ari Ben Aviator Inc · Fort Pierce, FLN20894Kampel Thomas E · Wellsville, PAN2090MMartin Tumasz Caroline A · Ambler, PAN2095MDebusschere Paul A · Camarillo, CAN2096MLake Daniel J · Sandusky, OHN209RCCapece Richard N · Leonardtown, MDN2102MCrowley Independent School District · Crowley, TXFirst renewal noticeN2104MDisrud Roger G · Olathe, KSN2106MMulvey Tim C · Lockport, NYN2110MLemieux Robert R · Green Bay, WIN2112MWeigel John C · Natick, MAN2117MKramer Dean E · Bernville, PAN2118MChase 13 LLC · Wilmington, DEN2119MReed Jimmy A · Big Cabin, OKN2124MSantolla Robert D · Butler, PAN2126MWillis Charles D · Katy, TXN2131MSamson Philip C · Nashville, TNN2133MCrosswell Joe D · Springtown, TXN2135MJames Jeffrey D · Shady Shores, TXN2137MZewiske Joseph P · Mukwonago, WIN2139MMatt D Marrs · Bentonville, ARN2140MBobbe Allan R · Daytona Beach, FLN2143MVan Wagner Aerial Media LLC · Hollywood, FLN2146MPeterson Scott W · Garfield, KSN2149MAutry Lonnie E · San Jose, CA
Back to Piper J3C-65