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 ('2072504')
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 ('2072504')
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.
N6941EMohagen Henry C · Reva, SDN6942EOakland Dennis E · Glennallen, AKN6943ELasky Robert C · New Richmond, WIN6945EFiltration & Separation Technologies Inc · Glen Ellyn, ILN6947EFirestone Bradley W · Colville, WAN6948ESchrader Leif · Myrtle Point, ORN6949EFoster David B · Athens, TNN6950EMahler Jacson B · Reno, NVN6952EBeauchamp James W · Butte, MTN6954EBaylis Thomas B · Hattiesburg, MSN6955EGopalakrishna Prahlad Menon · Gibsonia, PAN6956EMetzger Greg · Clovis, CAN6958EAnderson Glenn Merrell · Duluth, MNN6966EVangundy Harold R · North Salem, INN6967ELafrance Nathan Alexander · Arlington, TXN6968EGladden David G · Wasilla, AKN6971EA Plus Aviation Inc · Wilmington, DEN6972EQuaile Leonard · Pendleton, ORN6974ENelson John A · Beverly, MAN6978ECrotts Jon A · Garden City, KSN6981EShaneyfelt Dwight A · Fortuna, CAN6983EBurkhardt Charles P Jr · Norco, CAN6985EThomas Steven J · Wasilla, AKN6988EPeterson Andrew B · Louisville, KYN6990EGray Jade · Odessa, TXN6991EHiggins Frank E · Rio, WIN6992EMikkelsen John P · Sebastopol, CAN6993ENewberry Wilma L · West Paducah, KYN6995EBennett Jeffrey S · La Mesa, CAN6999EMusgrove Jimmy Wayne · Delta Junction, AKN7000ESchweitzer Mark A · Susanville, CAN7001EMaupertuis Philippe F · Winchester, CAN7002EHickle William H · Inyokern, CAN7003EIndy Air Sales LLC · Anderson, INN7004EBoughan Patrick W · Vail, CON7006ELienke Kevin E · Beaver Dam, WIN7009ESutton Aircraft Salvage LLC · Palmer, AKN7010EVorpagel Richard H · Elkhorn, WIN7011ESimon James A · Daphne, ALN7012EGordy Melvin E · League City, TXN7013EPerkey Dan K · Rockvale, TNN7015ELovato Daniel C · Springville, CAN7017EWinn Larry V · Tucson, AZN7020EWise Rodney J · Brookhaven, MSN7021EDheedene Nicholas L · San Mateo, CAN7022EReece Steve · Darrington, WAN7028EHeidebrink Ronald · Loris, SCN7029ELewis Stephen · Lebanon, ORN7035EMetz Kevin Michael · Richmond, UTN7038EBrainerd Phillip S · Lake Placid, FL
Back to Cessna 175A