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.
N2660YRam Aviation LLC · Palmer, AKN266VFox Stephen A · Wasilla, AKN26905Indgjer Lawrence D · Pueblo, CON26AWAntique Aircraft And Automobile LLC · Van Alstyne, TXN270KCLeyva Kevin S · Wilbur, WAN2724XParrott Charles F · Bridgton, MEN2743XErb Weston Scott Trustee · Wasilla, AKN2755CR & B Aviation LLC · Oakland, MIN2802AHamilton Elson · Fort Bragg, CAN2805AWeibert Jarvis Tye · Kalispell, MTN2806AJackson Todd M · East Wenatchee, WAN2807AWoodley Aerial Leasing LLC · Walnut, ILN2817ARamey Shane · Buffalo, WYN2821ALewton John E · Belgrade, MTN2822MWendt Robert R · Sedona, AZN2823AMckinney Eric S · Hamersville, OHN2824AStrode Lawrence W · Naknek, AKN2826AConfer Gary R · Washougal, WAN2828ALatham Cory D · Great Bend, KSN2833AMamuzich Robert J DBA · Deming, NMN2834ADalton John B · Dallas, ORN2835AAllen Airplane LLC · Durango, CON2836ABond Darren R · San Antonio, TXN2838KOrtman James W · Bozeman, MTN2839AAldrich David S · Unity, MEN2843AKnerr Joshua DBA · Tehachapi, CAN2844ASmith Jon K · Adairville, KYN2847AKozacek Carter A · Duluth, MNN2848ALitzen Guide Service Inc · Kenai, AKN2849AMettler James T · Camas, WAN2850ASnyder Jason D DBA · Oakland, MDN2857ADusenbury Susan B · Walnut Cove, NCN2863ASkipper Jonathan H · Fayetteville, GAN2866ATruman Sparks Aviation LLC · Snyder, TXN2868ATaylor Eric C · Port Townsend, WAN2872AArdmore Aviation LLC · Russell Twp, OHN2873AAndelin Sheila P · Newport Beach, CAN2877ADutremble Donald L · Amherst, NHN2878AAero Garage Inc · Fort Myers, FLN2884ADowns M Todd · De Leon, TXFirst renewal noticeN2891ARegistered aircraftN2895AAirspace Aerial Media LLC · Saint Louis, MON2900ATct Aerial LLC · Waukesha, WIN2901CBright J Tobias · Seattle, WAN2902AMurray Kevin D · Moneta, VAN2902CPhil Ruhnke Construction Inc · Grangeville, IDN2903CWoodin Jacques C · Inglis, FLN2905ASutton Aircraft Salvage LLC · Palmer, AKN2906CNewman Dan A · Oak View, CAN2907CPiedmont Southern Associates Inc · Clayton, GA
Back to Cessna 180