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 ('2072602')
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 ('2072602')
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.
N2908CWilliams Daniel P · Afton, WYN2909ARasor William E · Brookville, OHN2909CHall Michael A · Spirit Lake, IDN2912CMarshalee Arizona LLC · Tempe, AZN2913CUnable Direct LLC · Kalispell, MTN2914CSterkel Jared · Anchorage, AKN2915CField Jeff H · Simi Valley, CAFirst renewal noticeN2916AMetro Service Air Inc · Fairbanks, AKN2917CParks Joseph S · Wilmington, NCN2919CRudolph Darren M · Wasilla, AKN291DCT G Dunn Plumbing Inc · Hulls Cove, MEN2921AStanford Jeffrey S · Anchorage, AKN2921CMensink David L · Preston, MNN2922AFowler Kenneth Russell · Locust Fork, ALN2923AWicklander Richard O · Spanaway, WAN2924ABennett Ross D · Anchorage, AKN2925AVan Der Molen Baron J · Readstown, WIN2925CElla Butte Farming Co · Ione, ORN2929CSinnott Simonis Lyle · Girdwood, AKFirst renewal noticeN2931AStrategic Aircraft Management LLC · Fairbanks, AKN2932AHenderson Steven A · Idaho Falls, IDN2933CLawson Matt E · Gobles, MIN2934ADixon Devin M · Las Vegas, NVN2935CSuez Jose F · Tracy, CAN2936CSale Reported · Stoughton, WISale reportedN2938AKoons John D · Waterville, MEN2938CKeller Dylan M · Meridian, IDN2940ABarnett David E Trustee · Anchorage, AKN2943AGraham Jason J · Anchorage, AKN2943CBaas Brian · Cambridge, MNN2944AWalker Travis J · Wasilla, AKN2944CHenry Kent · Prescott, AZN2946ARuach Ministry · Dover, DEN2946CMannis Arthur · Somers, NYN2947CHess Alexander · Virginia Beach, VAN2948CTundra House Tailwheel Club LLC · Willow, AKN2949AEllis Sterling M · Scottsdale, AZN2950CHenry'S Dragline Service LLC · Winona, MNN2952AWeyl George R · Bigfork, MTN2952CToil Oregon Vineyards LLC · Walla Walla, WAN2957CCurrier Dustan · Fairbanks, AKN2958CSale Reported · Anchorage, AKSale reportedN2960AGallman Alexander C · Livingston, TXN2961AMerrill Richard C · Chuckey, TNN2962AKapsner Mark W · Willow, AKN2963CMcmillian Tommy D · Wasilla, AKN2965CBauer Joachim · Rhome, TXFirst renewal noticeN2966ACroffut David P · Anchorage, AKN2968AMcdowell Claude Michael · Anchorage, AKN2970CClegg Bruce R · Brentwood, CA
Back to Cessna 180