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.
N5094RHigh View Air LLC · Driftwood, TXN5095RTraining Planes LLC · Tampa, FLN50967Sellers Raymond L · Trussville, ALN5096HMyhre Norman G · Hixton, WIN50988Propability One LLC · Daytona Beach, FLN5098RWilliams Austin T · Sheridan, INN5099RFly High Aircraft Sales LLC · Ocilla, GAN509SMCompton Stephen · Kennewick, WAN5105QBailey Glenn E · Oldenburg, INN5107HFlyit LLC · Camas, WAN5113QTri-County Aviation LLC · Lawrenceburg, TNN5117QBush Thomas D Jr · Cypress, TXN511PTCappe Investment Group LLC · Homestead, FLN51213Shelley Aaron J · Corbin, KYN5121QClift William R II · Princeton, KYN51221Provost Kevin H · North Swanzey, NHN5122R1st Clev-Mar LLC · Lakeview, ARN5123RGiving Wings Aviation LLC · Traverse City, MIN51249Flying Turkey LLC · Flower Mound, TXN5124RGarrison Randy L · Queen City, TXN5125DValdes Eusebio · Miami, FLN5126QAvco Patrol LLC · Lyndon, KSN5126RAirborne Investors Corp · Buford, GAN5127HSmith Dan R · Montrose, SDN5127RAmerican Industrial Laundry · Lander, WYN5128RBend Aircraft Mechanics LLC · Bend, ORN51297Ingram Dale D · Klamath Falls, ORN5129QWaters John E · Renton, WAN5130RShamp Jimmy L · Fresno, CAN5131RMlt Operations LLC · Traverse City, MIN5132HMohnacs Joseph T · Mount Laurel, NJN5132QHauptman Ben · Alexandria, VAN5133QReed Aero Group LLC · Hendersonville, TNN51379N51379 LLC · Galena, OHN5137RSchmeelk Darrin D · Thompson, CTN5138RBell Ornithopters Flying Club Inc · Eastlake, CON51395Rush David A · El Dorado, KSN5140QMccoy David J · Perryton, TXN5141RServant Air Ministries Inc · Merritt Island, FLN5144RBuffalo Flying Club Inc · Ayr, NDN51470Merryman Stephen R · Beach City, TXN5147HBeyond Willpower Inc · Shreveport, LAN5147KCline Aircraft LLC · Mena, ARN5147NMace Robert C Jr · Gold Canyon, AZN5147RKirkland Kerry G · Spring, TXN5148HMalad Aviation LLC · Bliss, IDN5149R5149r LLC · Manhattan, MTN514MDPerez Pedro J · Mayaguez, PRN514RBOsprey Holding Company LLC · Foley, ALN5151RLuszczek Christopher L · Berkshire, NY
Back to Cessna 172M