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 ('2072732')
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 ('2072732')
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.
N7593ST-Craft Aero Club · Nampa, IDN7594SGibbs John D · Victoria, TXN7596SLoftin Nathan E II · Pompano Beach, FLN7597SRainier Ranch LLC · Enumclaw, WAN7598SOz A&P LLC · Tifton, GAN7599SNull Perry D · Gallup, NMN759AAJames W Strider Jr Dmd Pc · Augusta, GAN759ABChiaramonte Karen M · Mattawa, WAN759AC2 Ba Pilot Nyc Corp · Wilmington, DEN759AEWood Don C III · Wilder, IDN759AJChesapeake Flying Association LLC · Annapolis, MDN759ALSwensen Les · Ilwaco, WAN759APMccann Eric David · South Jordan, UTN759ARRegistration Pending · Aberdeen, MSRegistration pendingN759ATGrisham Kyle E · Huntsville, TXN759AUInternational Air Services Inc Trustee · Carson City, NVN759AYGrimmett Lawrence · Boise, IDN759BC43rd Aviation Flying Club Inc · Wethersfield, CTN759BEBates Andrew T · Sandpoint, IDFirst renewal noticeN759BGMorey Bruce · San Diego, CAN759BJMohawk Flying Club Inc · Ada, MIN759BKWolkerstorfer Chad · Little Canada, MNN759BLBoney Craig D · Bethel, AKN759BNHigh Flying LLC · Bakersfield, CAN759BPHolbrook Roderick Wayne · Puyallup, WAN759BSHanson John Phillip · Shenandoah, TXN759BTClements Jimmie L · Durant, OKN759BUMarin County Sheriffs Office · San Rafael, CAN759BVPrado Farms LLC · Helm, CAN759BXBurnett Jon S · Sevierville, TNN759BYAlmyra Aero LLC · Stuttgart, ARN759BZThompson Builders Corp · Novato, CAN759CBBarham Allen · Fort Worth, TXN759CCArmour Robert J · Longs, SCN759CDBrentco Aerial Patrol Inc · Canton, OHN759CELinear Dimensions Semiconductor Inc · Fort Myers, FLN759CGJohnson Claude III · Dalhart, TXN759CJForster Richard H · Gallatin, TNN759CNElite Aviation LLC · Sewell, NJN759CRCross Richard R II · Farmington, NMN759CSSchaefer John G · Rockford, ILN759CTN759ct LLC · Plymouth, MNN759CUFlight Club Utah LLC · Lindon, UTN759CVAbcd Farms Inc · Fitzgerald, GAN759CYVincent Ron · Glenwood Springs, CON759CZCummings Donald · New Castle, INN759DBRal Aviation LLC · Arnold, MON759DCBlackerby Ted L · Spicewood, TXN759DFJtss LLC · Selah, WAN759DGEpicarian Air LLC · Seeley Lake, MT
Back to Cessna 182Q