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 ('9601302')
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 ('9601302')
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.
N32158Balzer Francis X · Paragon, INN32159Dp131 Associates LLC · Chesterfield, VAN32162Preston Philip Edward · St Petersburg, FLN32168Nc 32168 LLC · Poughkeepsie, NYN32179Eckels Shelly · Shelbyville, KYN32183Dmb Aircraft Inc · Wilmington, DEN32186Erickson Kirk E · Warroad, MNN32193Marden Aero Services LLC · Erwinna, PAN32199Freeman William R · Lenexa, KSN321GHBartel Christopher H DBA · Williamsburg, PAN32472Hogan Thomas A · Fairfield, OHN39700Hogan Thomas A · Fairfield, OHN39708Wenglarz Maxwell D · San Pierre, INN39713Wolf Point Ranch LLC · Washington, TXN39714Liesch Robert H · Port Orange, FLN39716Sleeper William H · Bainbridge Island, WAN39717Upf-Sevens LLC · Hamilton, OHN39721Crnic Paul C · Chesterfield, MON39723Wenglarz Maxwell D · San Pierre, INN39725Diedrich Stephan A · Sandpoint, IDN39727Wolfe Don · Foresthill, CAN39734Krella Paul H · Poplar Grove, ILN39737Banky James D · Bolivia, NCN39738Taylor Trebor · Gerrardstown, WVN39743International Air Services Inc Trustee · Carson City, NVN39748N39748 LLC · Fredericksburg, TXN39752Bankston Aviation LLC · Mount Juliet, TNN39753Rare Aircraft Ltd · Faribault, MNN39754Registration Pending · Deltaville, VARegistration pendingN45373Registered aircraftN50176Gajewski Lorna R · Billings, MTN5078XMorozowsky Anthony M · Zanesville, OHFirst renewal noticeN620AMVintage Aero Machines Inc · Mulberry, FLN65621Wiemer Karl J · Norwalk, CTN66720Erickson Kirk E · Warroad, MNN679RJTravelaire Service Inc · Wilmington, DEN67VPLaw Office Of Victor F Poulos Pc · Las Cruces, NMN8749XBullion Bruce T III · Memphis, TNN9318Elliff Bud A · Windsor, CA
Back to Waco UPF-7