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 ('2072726')
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 ('2072726')
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.
N3156RChamplain Robert F · Canton, ILN3158RHelms Stephen G · Anchorage, AKN3159RSdmg Signs LLC · Las Vegas, NVN315TMSteadman Tony L · Arlington, TXN3161RDeertrack Aviation LLC · Oshkosh, WIN3162RSky West Aviation Inc Trustee · Albuquerque, NMN3165RReds Cable Tv Inc · Washington, NCN3166RVarnson Dale B · Brocket, NDN3168RRunck Russell E · Watertown, MNN3180RThomas Lance E Trustee · Mesa, AZN3182RSeven Hills Sky Divers Inc · Madison, WIN3183RRusso Anthony G · Melbourne Beach, FLN3184RGardner Daniel J · Alvord, TXN3186RHuey Gale R · Celeste, TXN3190RPace Richard · Leighton, ALN3191RLv Aviation LLC · Pompano Beach, FLN3192RFuchs Robert D · Easton, PAN3193RHolmes John H · Barto, PAN3195RPalmer Matthew B · Riverside, CAN3196RS & S Aviation Co · Ball Ground, GAN3199RUmina Michael P · Hopkinton, MAN3301RJuliet Zulu Holdings LLC · Dover, DEN3305RLivingston Sonja L · Redding, CAN3307RPhan Tam M · Charlotte, NCN3308RLocatelli Gabriel G · North Bend, ORN3310RSeitz Martin V · Brookfield, WIN3311RView From Above Inc · Columbia, CAN3312RParish Mark · Earth, TXN3315RTriple X Construction Inc · Camp Verde, AZN3316RBranstetter Jack · Ponca City, OKN3317RBanti Gustavo · Marco Island, FLN3321RGray Kerry L · Granbury, TXN3323RD&J Air Adventures Inc · Koloa, HIN3325RDresick Farms Inc · Huron, CAN3326RAnderson Patrick Alan · Ripley, WVN3327RLyman Gregory A Trustee · Traverse City, MIN333YTRegistered aircraftN3340RFrieze Rex · Fair Play, MON3341RKozlenko Roman · Irvine, CAN3344RStorm Water Services Inc · Redmond, ORN3345RJennings Mamie M · Springfield, ILN3346RGonzalez Oscar · Bedford, TXN3355RSkyhawks Flying Club Inc · Canton, SDN3358RHaydukovich Steven J · Phoenix, AZN3361ROlson Bartlet · Merrimac, WIN3362RLight Jeffrey D · Woodville, VAN3363REagles Flight LLC · Grove, OKN3368RRegistered aircraftAssigned, pending cancellationN3369RFenton Flyers Inc · Hillsboro, MON3373RSkylane N3373r LLC · Rancho Cucamonga, CA
Back to Cessna 182L