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.
N64001Alpha One Aviation LLC · Corona, NYN64007Baugh Tommye R · Star City, ARN64014Maynor Robert B · Mansfield, LAN64016Ponderosa Aviators LLC · Baker, MTN64017Pilots Today Inc · Berlin, MDN64020Bend Aircraft Mechanics LLC · Bend, ORN64023Rawson Aviation LLC · Collinsville, OKN64035Loomis Darwin · Mooreland, OKN64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeN64045Walker Robert · Chula Vista, CAN64046Biesecker Michael Gary · High Point, NCN64048Gray Peter A · Salinas, CAN64053Collins Thomas A · Orleans, MAN64061Stark Glenn M · Nampa, IDN64062M G Enterprises Of Albert Lea Inc · Alden, MNN64063Bowers Alan B · Bellevue, WAN64067Duvall Chris D · Tahlequah, OKN64074Green Norman D · Lake City, FLN64081Burrows Donna M Trustee · Grain Valley, MON64082Mcdonald Douglas W Sr · Cornelia, GAN64091Fahnestock John L · Melbourne, FLN64092Falcon William D · Elkhorn, WIN64095Righthand 2004 LLC · Charlotte, NCN64096Bissey Roy H II Trustee · Big Horn, WYN640MGAviate LLC · Green Bay, WIN64107Cmbb Enterprises LLC · Plainview, TXN64108Wiater Mark S · Crete, ILN64111Jasper Co Airport Authority · Rensselaer, INN64114Mccully Aviation LLC · Payson, AZN64119Augustus Aircraft LLC · Whitefish, MTN64120Ham Derek · Independence, ORN64134Torres Felix · Dallas, TXN64135Flying Mermaid LLC · Aiea, HIN64140C64140 LLC · Bloomington, INN64147Summit Aviation Inc · Kingston, NYN64154Jw Skyhawk LLC · Austin, TXN64155Lowcountry Flight LLC · Johns Island, SCN64157Christensen Jeffrey S · Wisconsin Rapids, WIN64159Flying 14 LLC · Spokane, WAN64160Glide Slope LLC · East Hampton, NYN64161Aom Aircraft LLC · Orlando, FLN64162Mccormick Philip D · Mount Pleasant, IAN64163Good Airplanes LLC · Oshkosh, WIN64165Weaver Lynwood J Jr · Raleigh, NCN64173Training Planes LLC · Tampa, FLN64174Sen Air Inc · Mckeesport, PAN64180Spanaflight LLC · Puyallup, WAN64184Arlington Flight Services Inc · Arlington, WAN64186Paraloft LLC · Mims, FLN64191Flycarolina LLC · Concord, NC
Back to Cessna 172M