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 ('2072604')
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 ('2072604')
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.
N5391DPope James D · Lewiston, IDN5394DBruce Gregory L · Yelm, WAN5395DLindberg Thomas W · Anchorage, AKN5399DWeeks Patrick · Anchorage, AKN545Providence Aerospace LLC · Choctaw, OKN571CRegistered aircraftN58SDBrusasco John Mario Trustee · Portland, ORN601NSchneider Bernard M · Battle Ground, WAN608LDWeldon Robert S · Tallahassee, FLN6098AMcknight Christopher M · Nampa, IDN6180Plane Fun Inc Tr Trustee · Snellville, GAN620MMRahill John G · Burlington, VTN62KJStephani Timothy M · White Lake, WIN74022Braatz Cannonf · Bend, ORN750Culver Marc D · Anchorage, AKN7505N7505 LLC · Deer Park, WAN755WUsda Forest Service Fepp · Malvern, ARN7767AWinged Bear LLC · Grafton, WIN7768AAmundson Scott E · Wrightwood, CAN7769APliska Alan T · Torrance, CAN7771AWells Jason R · Chugiak, AKN7779AHendry Rickey W · Apple Springs, TXN7780AWhitmore Jay R · Anchorage, AKN7783APhipps Laura P · Midland, TXN7785AZulu Forty One LLC · Anchorage, AKN7788AChambers Samuel S · Salmon, IDN7789AMersereau David H · Anchorage, AKN7790AHreshchyshyn Marta · Eagle River, AKN7805AJohnson Todd M · Hudson, WIN7806AFullerton Paul S · St Ignace, MIN7810ABlack Diamond Soaring Inc · Oley, PAN7813AKvichak Lodge LLC · Anchorage, AKN7818AGeoterra Inc · Eugene, ORN7821AKw Air LLC · Darlington, INN7853ARegistered aircraftN7854AMacglover Richard A · Ham Lake, MNN7857AEberhardt William J · Gig Harbor, WAN7864ACrestair Air LLC · Dover, DEN7868AFox Farley R · Britt, MNN7870AMerriman John R · Georges Mills, NHN7871ACantrell Dennis Owner · Conway, ARN7882AWayner Paul S · Anchorage, AKN7884AMcintyre Jon D · Fairbanks, AKN7890ARobinson Stephen K · Davis, CAN82266Klondike International LLC · Lewes, DEN847AFRegistration Pending · Boise, IDRegistration pendingN876SHPatton Michael D · Tygh Valley, ORN885CEOwens John · Camden Point, MON88666Vincze Andras · Anchorage, AKN888FAnderson David V · Bennington, VT
Back to Cessna 180A