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 ('2072724')
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 ('2072724')
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.
N2561QMariposa Aviation Inc · East Wenatchee, WAN2561RHeber Valley Flying Club · Park City, UTN2562QStiles Thomas W · Pocahontas, ILN2562RKehler Grain & Livestock · Saint Xavier, MTN2564RBusse William J · Twin Lakes, WIN2565RSanders David D · Alvin, TXN2566RRastetter Harold · Douglaston, NYN2567RGone Flying LLC · Loveland, OHN2570QGolden Thomas J · Bishop, GAN2570RSkyblazers LLC · Boones Mill, VAN2572RMladejovsky Michael G Trustee · Paulden, AZN2574RChauvin Junius · Franklin, LAN2576QHamilton Steve · Carson City, NVN2577RSchomaker Michael J · Pleasanton, CAN2582Q82q LLC · Glenwood, MDN2582RBergmann Robert A · Lake Placid, FLN2583RHigh Range Aviation Inc · Gooding, IDN2585RChristie Bruce W · Wasilla, AKN2586QErrington Aero LLC · Bellefontaine, OHN2588RPoplin Tristan · Frisco, TXN2589QMolek Eugene · Warren, OHN2590RMason John A · Scottsdale, AZN2591QDeadmond Matthew J · Princeton, CAN2593QRigoni Teresa Ann · Orting, WAN2594QBarer Scott I · Westlake Village, CAN2595RDierenfeld Michael E · Northwood, IAN2596QEvening Star Aviation LLC · Corvallis, ORFirst renewal noticeN2596RJones Jacob R · Rockford, TNN2597QCattles Kenneth M Jr · Georgetown, TXN2597RWing Frederick K · Milton, MAN2600QBivens Jason D · Duncan, OKN2600ROrlandella Vito P · Auberry, CAN2602RSiegel Jeffrey P · Snowmass Village, CON2603RHopper Jeremy G · Amity, ORN2606QElsayed Von Bayreuth Alaaeldeen Mohamed · Fairfield, CAN2608QMiller David C · Burlington, CTN2608RRegistered aircraftN2609QDawson Arden H III · Eagle Nest, NMN2612QLabarre Ben A · Hayward, WIN2614QBeyers Donald · Pana, ILN2614RWindh Steven R · Reedley, CAN2615RWolf Coy D · Ord, NEN2616QSutton Marshall T · Erick, OKN2617RFener Seth M · Claremont, CAN2618RMelton Edward A · Glendale, AZN2619QHoman Edward L · Cincinnati, OHN2619RRickert & Son LLC · Moses Lake, WAN2620QAkroyd Robert F Jr · Raton, NMN2624QKalarney Kerry T · Olathe, CON2625QSutton Aircraft Salvage LLC · Palmer, AK
Back to Cessna 182K