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.
N23325Pa-18 LLC · Hood River, ORN23339Avendeavor LLC · Snohomish, WAN23346Atlanta Airmotive Inc · Franklin, NCN23378Pinkerton Matthew L · Navarre, FLFirst renewal noticeN23379Almeida Donald J · East Bridgewater, MAN23403Dahl Lincoln · Saint David, AZN23413Brown Devin Richard · South Chesterfield, VAN23438Bradford III Properties LLC · Huntersville, NCN23446Vagabond LLC · Baton Rouge, LAN23449Mccombs Collin E · Milford, TXN23462Cubclub LLC · Clinton Township, MIN23463Colmark Bruce A · Sterling, ILN23464Tsi Holdco Inc · Virginia Beach, VAN23472Small Mark B · Walla Walla, WAN23495Stone J Bartley · Carrollton, GAFirst renewal noticeN234TWUplift Aviation LLC · Dover, DEN24503Bartlett Danny L · Tennessee, ILN24528Cub Club · Kunkletown, PAN24549Vand Flyre Klub · Newfolden, MNN24551Thomas Bruce W · Madisonville, TNN24556Murphy Joyce V · Hood River, ORN24558Pinkerton Tim A · Trotwood, OHN24570Johnson Michael T · Moatsville, WVN24574Parish Philip Pw Trustee · Galena, MDN24603Coleman William T · Portage, WIN24609Clay Wesley A · Harlan, IAN24621Luke Stanley Wayne Jr · Rochester Hills, MIN24632Robertson Jay J · Battle Ground, WAN24636Pitts Lynn Larry · Webb City, MON24643Silverman Nancy · Kenai, AKN24649Foot Phillip B · Hazen, ARN24654Lessard Timothy P · Ranier, MNN24686Larsen Rick D · Fond Du Lac, WIN24689Davis Ronches Inc · Belle Fourche, SDFirst renewal noticeN24694Keneston Mark G · Ballston Spa, NYN24705Vintage Piper Cub Racing LLC · Sheboygan Falls, WIN24716Gordon Thomas H · Titusville, FLN24739Saienn Orlando A Jr · New Castle, DEN24751Abbott Dylan L · Lompoc, CAN24758Air Combat Museum · Springfield, ILN24762Kucera Wayne N · Intl Falls, MNN24770Zumwalt B Joseph · Sheldon, ILN24785Tumilowicz John S · Waxhaw, NCN24796Scharnhorst William A · Lewiston, IDN247DPAerial Sign North · Lakewood, NJN24840Hubbard Aviation LLC · Boswell, OKN24846Fly8ma LLC · Big Lake, AKN24878Rudningen Eric G · Willmar, MNN24889Naca 130 LLC · Cameron Park, CAN24892Winemiller Todd L · Blanchester, OH
Back to Piper J3C-65