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.
N6826ERudolphi Ben M · Valdosta, GAN6828ESheppard Walter S · Troy, IDN6829ELay Steven K · New Vienna, OHN6830EJackson Thomas M · Florissant, MON6832EStuebner David M · Delanson, NYN6838EBognar Jeffrey L · Kinnelon, NJN6843ECampbell Ronald M · Upland, CAN6845EShores Kelly W · Thayer, ILN6849EHofer Perry L · Doland, SDN6850ESchott Nicholas F · Burns, ORN6854ERowe Cecil D · Knoxville, TNN6856EHigh Plains Agronomics Inc · Milliken, CON6859EAndersen Henrik T · Golden, CON6861EBeckerman George F · Mount Carmel, ILN6862EBostik Industries LLC · Green Cove Springs, FLN6865ESustek Jerry · Seattle, WAN6866EStuart Bradley J · Hillsboro, NDN6870ELentfer Sheryl A · Anchorage, AKN6873EWallace Joseph R · Winchester, KYN6875EElston Josh · Sterling, AKN6876EDunn Gary K · Paw Paw, ILN6877EBell Connor C · Maple Valley, WAN6879EWilliams James W · Friendsville, TNN6880EBartel Anthony E Jr · Ridgecrest, CAN6881EInternational Air Services Inc Trustee · Carson City, NVN6885EHeiser Reggie · Polson, MTN6886EHadley David C · Herriman, UTN6887EPatton Martin O · North Ridgeville, OHN6888ESteinhausen Darrell · Torrington, WYN6891EOakes Stephen · Joshua Tree, CAN6893EArmstrong Bruce · Port Orchard, WAN6895ETharp Marc B · Mulberry, FLN6896EPalmer Gregory Joseph · Niskayuna, NYN6898EOwen Jefferson G · Warrensburg, ILN6900EMitchell Jeannie · Holiday Island, ARN6901EBostik Industries LLC · Green Cove Springs, FLN6906EArnold Gerald D · Albuquerque, NMN6909EWhite Dewayne · Yreka, CAN6910EDakota Aircare Inc · Wagner, SDN6911EHannah Riley · Hillsville, VAN6913EHampton Richard A · Seymour, INN6914EDodge Donald A · Dupuyer, MTN6917ERegistration Pending · Lowell, MIRegistration pendingN6920EShoemaker Logan · Ruston, LAN6922ERall Charles J · Mansfield, OHN6923EBailey Charles T · Carthage, TXN6924EThomas Charles · Marathon, IAN6926ECheney Douglas A · Windsor, CON6928ESmith Richard B · Renton, WAN6933ERulo Michael L · Westcliffe, CO
Back to Cessna 175A