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 ('2072704')
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 ('2072704')
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.
N3909DDavidson Danny F · Anchorage, AKN3912DPmn Enterprises LLC · Fremont, WIN3914DKapowsin Air Sports Ltd · Shelton, WAN3915DCarlson Thomas J · Gilbert, MNN3917DBlue Sky Powers N3917d LLC · Dover, DEN3919DPallet Rack Surplus Inc · Conyers, GAN3927DRi Skydiving Aircraft LLC · Middletown, RIN3928DGallatin 182a Flyers LLC · Bozeman, MTN3929DAbidance Inc · Winthrop, WAN3930DColovich Barry L · Vernal, UTFirst renewal noticeN3931DTolman Cory A · Fallon, NVN3935DHudson Jon P · Bozeman, MTN3939DRed Baron LLC · Middletown, DEN3941DOrchid Aero LLC · Lakewood, CON3943DLoudan Christopher D · Trinidad, TXN3945DBarnett Lance · Fairfield, CAN3947DBellew James W · Pueblo West, CON3956DJohnson Justin R · Bonners Ferry, IDN3959DRandolph Clinton A · Bullhead City, AZN3962DMalone Parachute Club Inc · Williston, VTN3963DMaplewood Flying Association Inc · Dorset, VTN3968DFallon Jeffrey C · Berlin, MAN3969DNeal Clarence W · Markham, TXN3971DGreene Robert K · Athol, IDN3973DPatrick Arthur L · Rome City, INN3977DEasom William J · Thousand Oaks, CAN3981DDuncan C Todd Consulting Services LLC · Tucson, AZN3982DA P Leasing Inc · Wilmington, DEN3984DRaven Aviation LLC · Alexandria, VAN3988DEvarts Leslie A · Polson, MTN3990DKeselman Michelle V · Las Vegas, NVN3992DLeyda Aaron M · Bartlesville, OKN3995DNelson Bryce H · Keiser, ARN3996DHeritage Aviation Holdings LLC · Mesquite, NVN3997DBowe Timothy R · Minot, MEN3998DStewart Matthew L · Camano Island, WAN3BCBenedict Larry · Dexter, NMN3VQOff The Ground LLC · Austin, TXN4000DHortman Jennifer L · Murrieta, CAN4001DJohnson Randall S · Craig, AKN4002DVanburen Willard L Sr · Ashland, NEN4005DHarris Mark P · Arcata, CAN4011DSkydive Inc · Eagle Creek, ORN4012DEdgren Erik J · Oskaloosa, IAN4015DCotten Randy · Belgrade, MTN4016DBates Michael B · Medford, ORN4018DUnderhill Clinton T · Yuma, AZN4021D21d LLC · West Henrietta, NYN4028DDriebergen John A · Meridian, IDN4030DPaulson Glenn D · Oro Valley, AZ
Back to Cessna 182A