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.
N9274HWings Over Texas Holdings LLC · Denton, TXN92753Mccollum J R · Mount Pleasant, TXN92777Macatawa Flyers Inc · Allegan, MIN9277HChorman Spraying LLC · Milton, DEN92789N5746u LLC · Dover, DEN927TCWings Over Texas Holdings LLC · Denton, TXN92810Dilse Brian R · Grand Forks, NDN92817Millner James W Sr · Soldotna, AKN92837Staszak Sandra · Martinsville, ILN92845Hainet Aero LLC · Wilmington, DEN92855Falcon Flying Club · Mesa, AZN9285HOrion Aviation Aircraft LLC · Carlsbad, CAN92873Sonday Terrance P · Spring, TXN92878Jackson Richard L · Indianapolis, INN92886Lewis John E · Clayton, NJN92888Knudsen Wayne D · Dakota City, NEN92889Miller Andy · Marana, AZN92894Smith Rex H · Fort Bragg, CAN92908C-140 Company LLC · Pensacola, FLN9291HDawson William F Jr · Port Hueneme, CAN9292HBlackhawk Flying Club Inc · Rockford, ILN92934Service Oriented Aviation Readiness (Soar) · Bolivar, MON92945Fla Inc · Wilmington, DEN9295HMiami Seaplane Tours Inc · Miami, FLN9296HSmith Richard A · Burnsville, MNN929BMSuntops Aircraft Holding LLC · Lakeland, FLN92MMAircraft Guaranty Corp Trustee · Oklahoma City, OKN9304HWischmeyer Matthew R · Hopewell Junction, NYN9306HAnycomm Corp · Gold River, CAN9310HLilienthal Donald W · Cyrus, MNN9313HFlying Ten Flying Club · Phoenix, AZN9319HHoffman Stanley L Jr · Bethel, AKN9320HPlane Tail LLC · Bethany, CTN9334HFree State Flying Club · College Park, MDN9337HLorraine'S Blue Sky Aviation LLC · Norman, OKN9338HSchab Davis Maragaret A · Spangle, WAN9341HAndreas Neil A · Yakima, WAN9342HGutierrez Ricardo · Downey, CAN9344HBarnstormers Flying Club Inc · Pulaski, TNN9347HWings Like Eagles LLC · Wilmington, DEN9348HDeshazer Bill G · Gladewater, TXN9351HBrown Daniel Thomas · Layton, UTN9356HQuad Cities Aero LLC · Bettendorf, IAN9359HWarren Flying Club · Troy, MIN935PTTailspin Tommys Inc · Port Townsend, WAN9365HAugusta Aviation Inc · Agusta, GAN9366HPowell Jonathan L · Violet Hill, ARN9367HDeralex Airways LLC · Miami, FLN9372HN9372h LLC · Wilmington, DEN9377HAir Advantage Inc · Mount Pleasant, IA
Back to Cessna 172M