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 ('2072418')
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 ('2072418')
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.
N61585Mele Michael L · Fairview, ORN61586Evalt Ralph D II · Dillingham, AKN61588L&W Aircraft Investment LLC · Homestead, FLN61594Hawk Aviation Inc · Rush City, MNN61605Blake Ernest Ronald · San Jose, CAN61606Swafford Charles T · Humble, TXN61607Maier Dennis J · Morristown, SDN61610Sugarpine Skies LLC · San Jose, CAN61615High Flight Academy LLC · Allison Park, PAN61622Lexington Flying Club · Richmond, KYN61625Chapline Curtis · Cypress, TXN61628Nationwide Aviation LLC · Hudson Oaks, TXN61630Jerome Pester Farms Inc · Hingham, MTN61631Jones Donald T Jr · Barrigada, GUN61633Rotor Spec Aviation LLC · Fort Lauderdale, FLN61635Meridian Aero Club Inc · Midland, MIN61637Amelia Reid Aviation LLC · San Jose, CAN61640Cooper Michael A · Rohnert Park, CAN61641Handzo Anthony J · Roseville, ILN61642N61642 LLC · Lowell, MIN61643Spence Stephen E · Mancelona, MIN61645Lima-001 LLC · Muscatine, IAN61648Tnt Airworks LLC · Hibbing, MNN61651Clw Aviation LLC · Springville, ALN61655Air Planes LLC · Soddy Daisy, TNN61656Dismang Chad C · Boynton, OKN61657Bell Ornithopters Flying Club Inc · Eastlake, CON61658Nationwide Aviation LLC · Hudson Oaks, TXN61659Bowerman Richard E · Wetmore, MIN61663Mohamed Eman Z · Lubbock, TXN61670Registered aircraftN61671Charlotte Flyers Inc · Fort Myers, FLN61672American Patrols Inc · Midland, TXN61676Vectors LLC · Sterling, VAN61677Morcom Aviation Services Inc DBA · Everett, WAN61680Kaye Linda · Grove, OKN61683Migdalski Randall C · Pembroke Pines, FLN61684Odyssey Aircraft LLC · Topeka, KSN61687Advanced Rehab Specialties Pa · Leesburg, FLN61689Bc 414 LLC · Los Angeles, CAN61692Pittsburgh Institute Of Aeronautics · West Mifflin, PAN61696Bakker Margaret E Trustee · Petaluma, CAN61697L&W Aircraft Investment LLC · Homestead, FLN61699Erickson Steve · St Michael, MNN616AADowns Kenneth · Houston, TXN61700Torres Ramon L · Mulberry, FLN61701Jls Aviation LLC DBA · Fredericksburg, VAN61703Beising Steven · Las Vegas, NVN61704Glick Mervin L · Stanardsville, VAN61707Spartan National Holdings LLC · Missoula, MT
Back to Cessna 172M