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 ('2072716')
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 ('2072716')
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.
N3439SProtsman Bryan D · Anchorage, AKN3440SLynch Chris A · Sedro Woolley, WAN3441SSun Technology LLC · Cheyenne, WYN3442SRail Birds · Clearfield, UTN3443SWilliams Forest Chem LLC · Columbus, GAN3444SBraha Thomas I · Mansfield, PAN3661UGlenney Christopher · Milan, NHN3662UBenter Wayne D · Crosby, NDN3663UWilliams James R · Austin, TXN3664UAir Skylane LLC · Boulder, CON3665UBlue Skies Aviation Of Wi Inc · Pulaski, WIN3672UD W Clark LLC · Newton, NJN3676UGregg Michael · Orlando, FLN3678UCaven Dennis L · Santa Rosa, CAN3679UPowerhouse Coach Inc · Idaho Falls, IDN3684UToews Berton J · Casper, WYN3686UEnvi Adventures LLC · Troutdale, ORN3688UTaylor Aviation Inc · Fort Benton, MTN3692UPineview Ac Sales LLC · Bedford, WYN3694UPara Tactics LLC · Shelton, WAFirst renewal noticeN3698UJk Fly LLC · Abie, NEN3700URydberg Lawrence · Albuquerque, NMN3701UBowley Steven Jon · Phoenix, AZN3702UCc Flyers LLC · Corpus Christi, TXN3706UBrownfield Ken F · Boonville, MON3709UMoser Scott M · Pisgah Forest, NCN3710UFollette Aviation LLC · Scottsdale, AZN3712UVarian Dennis D · West Lafayette, OHN3713UDaggy Curt L III · Red Bluff, CAN3714USchaffer John Paul · Prior Lake, MNN3715JSmoot Nathan · Fairbanks, AKN3716UPlane Fun Inc Tr Trustee · Snellville, GAN3719UOlsen Marvin J · Kent, WAN3721UDanko Lawrence G Trustee · Paden, OKN3722UDudash George M · Escondido, CAN3724URouter Bit Service Co Inc · High Point, NCN3728UMaupin Daniel D · Corvallis, ORN3730UWarren Kevin · Berger, MON3732UGifford Tracy G · Stephenville, TXN3736UDelong Don R · Wheeler, MIN3739UYown Inc · Ethridge, MTN3740UFlight Club 502 Inc · Louisville, KYN3743UHughes Kathryn G · Council, IDN3745UAnglemyer Mark · Piketon, OHN3746UUltimate Internet Access Inc · Wrightwood, CAN3748UChristy Allen C · Farmington, NMN3752URegistered aircraftN3755UHendrickson Justin R · Twin Falls, IDN3763UHunter James C · Shelton, WAN3769UNorthey Scott A · Mazama, WA
Back to Cessna 182G