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.
N26088Price Laurence A · Morrison, CON26096Follansbee Art · Fairfax Station, VAN26097Halmans John D · Baker, MTN26099Tiberg Robert E · Sparta, TNN26109Martin Devon R · Memphis, MON26147Ranger Airfield Foundation · Ranger, TXN26168Young Jeremy J · Hood River, ORN26169Simpson Robert W · Farmerville, LAN26182Mallach Kenneth L · Gatesville, TXN2646KEckert Robert E · Edgewood, TXN26702Gregg Delvin K · Durango, CON26720Donner Paul A · Hurst, TXN26739Ferguson Mark R · Lonoke, ARN26746Ehlies Tim D · Miami, FLN26753Steube George · Jackson, MSN26754Esterly Bryan L · Hope Mills, NCN26761Haun Justin R · Belton, TXN26762Barlow James D · Mohave Valley, AZN26765Mullin Douglas P · Salem, NHN268183n6 J3 LLC · Jamesburg, NJN26820J 3 Cub Corp · Miami, FLN26833Hanz Joseph L · Ford City, PAN26838Gross Scott A · Williamsburg, VAN26868Musser Alvin M Jr · Memphis, MON26923Zollars Thomas B · Dallas, TXN26931Chandler Elijah Js · Pilot Mountain, NCN26950Peffley James D · Melrose, FLN26978Davis Melvin Howell Jr · Ridgeway, SCN26989Applegate Paul H · Queen City, MON27006Bielefeld James L · Kenai, AKN27013Andresen Paul S · Chandler, AZFirst renewal noticeN27016Porter Michael P · East Liverpool, OHN27019Ashford John R Jr · Pagosa Springs, CON27020Johnson Aaron D · Granger, INN27023Smolin Howard I · Troutdale, ORN27033Hill Judith L · Carriere, MSN27048Trissell Flying Service · Clarksville, TXN2707ADenning Joel · Midland, VAN27111Peters Ben W · Seminole, TXN27123Hollingsworth George S · Finley, TNN27139Ag Leasing LLC · Wilmington, DEN27143Olson James A · Hixton, WIN27144Lee Aero LLC · Wichita, KSN27145Registration Pending · Verdi, NVRegistration pendingN27147Bray Max W · Dora, ALN27153Piper David S · Bartlesville, OKN2715MHolt James D · Mount Vernon, WAN27162Pimentel Carolyn J · Etna, CAN27164Zatloukal Jan · Payette, IDN27183Gidzinski David A · Weirsdale, FL
Back to Piper J3C-65