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 ('2072735')
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 ('2072735')
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.
N230MMLackey Matthew Allen · Peachtree City, GAN2358SBornhoft Jerome T · Riverton, WYN2389SPhillips Aviation Enterprises Inc · Petoskey, MIN2396SLebeouf Bros Towing LLC · Houma, LAN240RG182rg LLC · Bellevue, WAN2431SDavis Girls LLC · San Jose, CAN246TFMorgan Daniel D · Topeka, KSN24ELDye Eric M · Winters, CAN250LMenefee Scott A · Los Banos, CAN2526SPlane Nutz LLC · Sugar City, IDN2625SSierra Aviation LLC · Plaza, NDN287BWDaniels Kelly M · Humble, TXN28JWMower Michael · Kalispell, MTN29070Buzick Carey B · Fargo, NDN298JCNiemeijer Meindert · Coralville, IAN300SKKayrouz Sebastien V · Richardson, TXN310VMSkrzecz Michael T · Phoenix, AZN314TRShalexco LLC · Salt Lake City, UTN31FR31fr LLC · Bigfork, MTN323PCTriego Inc · Dumas, TXN326AMAviatzone LLC · Fort Lauderdale, FLN333HADoran Jeff · Westerville, OHN333YFEagle Aviation LLC · Delray Beach, FLN33LDLeahey Thomas C · Huntington Beach, CAN343CEDeriso Jordan L · Arcadia, FLN34SWCobb James E · Collierville, TNN362BCWing Nutz LLC · Redondo Beach, CAN379SSky Chasers LLC · Mount Vernon, WAN381AHGeodata Aircraft Management Inc · Wilmington, DEN3NFRooster Partners LLC · Santa Monica, CAN418LGm Farm Service LLC · Santa Teresa, NMN420RFritz David W · Kerrville, TXN423DKOliveira Avelino Da Mota · Aventura, FLN4304RMoore Robby J · Salem, ORN4322RKing Air Charter LLC · Zanesville, OHN4359RAircraft Resources Inc · Crescent City, FLN4372RKennemer Farms Inc · Carter, OKN4424RBazemore Bryan P · Charlotte, NCN4428RCantrell Boyd T III · Ocala, FLN4475RBrown Charles A · Portland, TXN453WMAerostar Companies Inc · Dover, DEFirst renewal noticeN454DMGerman George Derlin · Petaluma, CAN456BHCastleton Real Estate & Developlment Inc · El Monte, CAN456DJSingle Raj Pa Inc · Seattle, WAN4602SKeniston Kimberly A · Tyngsboro, MAN4609SN4609s LLC · Verona, WIN4621SSlayton Oil Corporation · Roswell, NMN4631SHastings David M · Waterloo, NEN4633SKovac Francis J · Nantucket, MAN4649SBrigger LLC · Wilmington, DE
Back to Cessna TR182