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 ('2072712')
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 ('2072712')
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.
N3366YCrawford Stephen E · Corinth, TXN3370YBrink Brittnie L · Baldwin, WIN3371YChavers Finley L · Newnan, GAN3374YRegistered aircraftN3376YFly Greater Breezewood LLC · Clearville, PAN3380YLaramie Flying Club Inc · Laramie, WYN3382YJenkinson John III · Lakin, KSN3383YJohnson Brian B · Monroe, LAN3384YOliveira John S · Plant City, FLN3385YNoah Aviation LLC · Ellabelle, GAN3387YBhogal Balvinder S · Biloxi, MSN3388YMeeks Peris M · Gardena, CAN3390YHead John T Jr · Port St Joe, FLN3394YNolt Ivan M · Mount Solon, VAN3395YTriple J Aviation · East Quogue, NYN3396YPlane Fun Inc · Lewes, DEN3398YBobbitt Michael · Lamont, OKN3503YNorthern Lights Renewables LLC · Condon, MTN3504YThigpen Alec DBA · Spanish Fort, ALN3507YAyers Curtis W · Greenback, TNN3509YAnderson Kevin · Verona, NDN3511YJ F Jones Logistics LLC · Dallas, TXN3514YCielakie Edward W · Dracut, MAN3515YInflyt LLC · Carlsbad, CAN3516YMks Aviation LLC · Port Orchard, WAN3517YRobles Serafin M · Cynthiana, KYN3518YMcaninch Shawn R · Albia, IAN3519YWeber Larry F · New Paltz, NYN3521YSportsman Airpark Inc · Newberg, ORN3522YBohlen Thomas R · Hudson, WIN3917YSmf Multi Sports LLC · Lewes, DEN425RBAkguc Cengiz · Lantana, TXN4449XBurns William R · Greensboro, GAN444LLWolfson Alan B · Loveland, OHN505JRParker Matthew · Cloudcroft, NMN509BWAnderson Richard D Jr · Remus, MIN533TDChristopher Schultheis Inc · Colton, WAN567XCovert Tim · Portland, ORN636WCMcgivern Mark M · Fountain Hills, AZN65CFSanders David T · Flagstaff, AZN66RXRegistered aircraftN69ELLewis Ethel M · Castro Valley, CAN707BSConboy Enterprises LLC · Lexington, KYN711NGHummingbird Air Service · Lincoln, NEN720WTBlain Monte W · Joliet, MTN752DMS&M Holdings LLC · Oak Ridge, LAN777WRFoley James V · Houston, TXN804PMSmp Outdoors Inc · Joseph, ORN82ADAdams Aircraft LLC · Wilmington, DEN876CGGreen Carlton · Carmel Valley, CA
Back to Cessna 182E