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 ('2072624')
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 ('2072624')
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.
N481QAdams Eddie · Senath, MON4KXHorseshoe Bar Land & Livestock LLC · Gillette, WYN5478JBuck Loenard J · Curtice, OHN55KAEvans Dick Trustee · Riverside, CAN570JSRust James P · Seymour, INN591NCPotto Aviation Inc · Wilmington, DEN600CGAnderson Cody J · Orono, MEN60100Malaspina Anthony J · Caldwell, IDN60710Johnson Douglas D · Sacred Heart, MNN61266Osborn Douglas · Madison, WIN61537Coplin Christopher S · Anchorage, AKN61576Nelson Bruce T · Healdsburg, CAN61632Cost Garret Alan · Tulalip, WAN61653Michel Daniel T · Sterling, AKN61662Huston Stephen M · Hollister, CAN61728Henderson James Ross · Garden Prairie, ILN61758Skywagon Aero LLC · Wilmington, DEN61781Ryan Good Aviation LLC · Sioux Falls, SDN61782Schroeder Rodger · Chugwater, WYN61792Turnbull Jason D · Wasilla, AKN61798Mayo Michael E · Boerne, TXN617RRed Baron LLC · Middletown, DEN61851C-180 Kbn LLC · East Lyme, CTN61854Timm Robert S · Minneapolis, MNN61874Erickson Kirk E · Lake Havasu City, AZN61877Harrison Jason J · Walla Walla, WAN61938Davis Larry M · Rathdrum, IDN61946Straight And Level Aeromedical LLC · Billings, MTN61999Aircraft Structural Repair Inc · Hamilton, MTN63130Box Talon · Cotulla, TXN63145Morin James R · West Ossipee, NHN63166Chucks Aircraft LLC · Hartland, MEN63242Douglas Dustin D · Tea, SDN63267W A Redgate · Crescent Valley, NVN63336Murry John · Anchorage, AKN63368Lorenzen Kraig Elmer · Pagosa Springs, CON63430Marr Brandon J · Monmouth, ORN63458Fowler Ron · Lopez Island, WAN63525Mickler Andrew E · Wasilla, AKN63534Gaudet Edward · Winthrop, MEN63554Nuovo LLC · Portland, ORN63579Ollmann Paul W · Poplar Grove, ILN63595Beard Bruce H · Pocatello, IDN63638Skywagon LLC · Wilmington, DEN6374KDls Holdings Inc · Lewes, DEN64044Johnson Lance D · Duluth, MNN64099Tullio John P · Edgewood, TXN64109Bickford Shawn A Trustee · Big Lake, AKN64153Davies Thomas V · Chula Vista, CAN64167Registered aircraft
Back to Cessna 180K