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.
N42911Kenney Stuart C · Atlanta, GAN42912Forouzan Fardad Trustee · Poway, CAN42919Tarnutzer Aviation LLC · Wayland, MIN42941Nistler Steve W · Helena, MTN42947N42947 LLC · Panama City, FLN42949Niemeyer Donald C DBA · Hobart, INN42951Tiedt Randy · Parkville, MON42955Brown Donald E Jr · Jonesboro, ARN42967Brook Daniel L · Marshall, INN42972Anderson Mike D · Mc Alpin, FLN42974Tracy Lanning Construction LLC · Westminster, SCN4297547q LLC · Eau Claire, WIN42980Friday Dale C · Santa Cruz, CAN42EMNbc Sales LLC · Somerville, TNN42KCChatham Kenneth W · Montross, VAN447WLM5-210c LLC · Castle Pines, CON4553SMinion Air Inc · John Day, ORN472BWCernek Megan Faith · Elton, LAN491AFMeyer Terry L · Wayne, NEN499WLMatthews Joseph D · Farr West, UTN4WSZeller Robert A · Oro Valley, AZN5245XPlane Fixer LLC · Ball Ground, GAN52CRCairns Douglas S · Bozeman, MTN545DTSkahill Earl DBA · Denver, CON599CPCoons Aircraft Services Inc · West Palm Beach, FLN601MBRegistration Pending · Ridgely, MDRegistration pendingN6394SLincoln Air LLC · Kalispell, MTN64RBBurnett Ramon R · Alpine, CAN65AMDorroh Frederick A · Ardmore, OKN660MRWilson Process Instrumentation Calibrations Inc · Muskegon, MIN667WBMcleod Patrick J · Overgaard, AZN68VBBeede Curtis M Trustee · Maineville, OHN68VTAir Positive LLC · Selbyville, DEN696MMShimoda Aviation LLC · Hawthorne, FLN70511Tanner Carlton · Coupland, TXN70513Hummer Ernest · Bonner, MTN70517Southern Aviation LLC · Griffin, GAN70521Gray John R · Cornville, AZN70538Nordic Air LLC · Buffalo, MNN70560Blue Sky Flyers LLC · Toccoa, GAN70563Missouri-Stone Co · Cartwright, NDN70987Sutherland Jason · Auburn, WAN744DPAviation Components Inc · Tarzana, CAN745XColson Troy D · Crystal River, FLN747WGWhiskey Gulf Aero LLC · Deland, FLN777RGLow Matthew N · Clearwater, FLN77APNelson Jeffrey R · Lebanon, OHN800LC54 Aero LLC · Spade, TXN826KJHlm Aircraft LLC · Marion, MSN832PMCunningham William R · Broken Arrow, OK
Back to Cessna 182L