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 ('2072618')
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 ('2072618')
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.
N91397Lucero Andrew R · Duluth, MNN91399Copper River Airmotive LLC · Copper Center, AKN91430N91430 LLC · San Antonio, TXN91439Mod Flying LLC · Elkhorn, NEN91464Breard Armand C · Monroe, LAN91470Sky Sailing Inc · Warner Springs, CAN91475Johnson Robert L · Douglas, AKN91476Petersen Greg · Chelan, WAN914FCSinibaldi Glenn · Highland Park, NJN9333CDunkley Bret Y · Kotzebue, AKN95EAFray Jonathan C · Wasilla, AKN968KOpheim Kurt · Minnetrisia, MNN96LGTaildragger LLC · San Ramon, CAN9702GZulu LLC · Blaine, MNN9704GJohnsons Aero Ag Inc · Box Elder, SDN9707GBurns Patrick · Carnation, WAN9708GDma Enterprises LLC · Fort Worth, TXN9710GThompson William G · Mattawa, WAN9711GBurcham Robert A · Anchorage, AKN9712GReynolds Frederick A · Pilot Point, AKN9713GKochert Timothy B · Anchorage, AKN9715GMonfore Mark A · Wasilla, AKN9717GBurley Mark A · North Pole, AKN9718GCain Curtis S · Reno, NVN9720GZarones Erik R · Paris, TXN9721GFahrenbruck George · Anchorage, AKN9725GMathis Isaac Thomas · Fletcher, NCN9726GIrc Holdings Ltd · Allentown, PAN9727GInternational Air Services Inc Trustee · Carson City, NVN9729GBurch Gerald T · Lake Charles, LAN9730GMcginty Flying Service LLC · Jones, LAN9732GFulcher David B · Glendale, AZN9733GZimmitti Andrew · Mclean, VAN9736GBrakey Richard F · Amarillo, TXN9737GZamoruev Alexander Vladimirovich Trustee · Anchorage, AKN9739GBjork Richard J · Brackettville, TXN9740GKestrel Kat LLC · Wilmington, DEN9748GKlamar Spraying Inc · Gatzke, MNN9750GGee Richard L · Seattle, WAN9751GJanes John L Jr · Anchorage, AKN9754GWings Aircraft Leasing And Services LLC · Wasilla, AKN9764GSicheneder Scott · Wasilla, AKN9767GCottingham Dwain R · Attica, INN9773GCooper Jeffrey B · Eagle River, AKN9780GCondren Henry W · Bolivar, MON9782GBoyd Derek · Deer Park, WAN9783GSatterfield Whitney Ann · Fort Worth, TXN9901VMinske Troy · Princeton, MNN9902VEuroaviation Inc Trustee · KematenN9906VStruempler Jed E · Anchorage, AK
Back to Cessna 180H