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.
N80185Aviation Training Inc · Cameron Park, CAN80186J J Jenkinson Inc · Meade, KSN80187Amalong Timothy M · Tucson, AZN80189Smith Darvin L · Atlanta, GAN80202Barber Chester M · Haleyville, ALN80205Olear Inc · Evansville, INN80208High Country Aviation LLC · Lyman, WYN80210Atlanta Air Academy LLC · Kennesaw, GAN80213N80213 LLC · Wilmington, DEN80214Delta Capital Inc · Blair, NEN80218Tom Hassenfritz Equipment Co Inc · Mount Pleasant, IAN80230Fly Nh Aviation LLC · Bow, NHN80238Hess Garrett J · Fullerton, CAN80239Borreson Anthony · Mariposa, CAN80246Lincoln Skyways Inc · Lincoln, CAN80248Mtm Deland LLC · Deland, FLN80251Harrison Social Flites Inc · Harrison, OHN80254On Glideslope LLC · Middletown, DEFirst renewal noticeN80263Breton Yacht Co LLC · Schenectady, NYN80267Bisson James H · Piercefield, NYN80270Fisher Robert · Shoreacres, TXN80277Usaeroflight LLC · Greenville, SCN80278Baur Ronald N · Gig Harbor, WAN80279Tueller John D · Spring Creek, NVN80282Nguyen Nhu-An T · Bethesda, MDN80283Barxbar Aviation LLC · Mesa, AZN80291Davidson Doug W · Newcastle, WAN80295Legacy Skies Aviation LLC · Rogers, ARN80298N80298 LLC · Miami, FLN80299Mountain Air Aviation Inc · Bethesda, MDN80300Ryther Jonathan W · Redlands, CAN80304Matthews David A · Anchor Point, AKN80307Hughes Fredrick A · Oklahoma City, OKN80322Mt Aviation LLC · Fairbanks, AKN80326Fly Lugu LLC · Southwick, MAN80327Highland Rim Aviation LLC · Springfield, TNN80331Johnson Shem E · Bonners Ferry, IDN80332Lamb Joseph M · Conway, ARN80333Coeytaux Britton Marielle G · St Helena, CAN80335Rawareo LLC · Warsaw, MON80336Joyal Alfred N III · Marquette, MIN80338Maldonado Monell Julio · Carolina, PRN80340Tangojuliet Aviation LLC · La Porte, INN80342Spanaflight LLC · Puyallup, WAN80347Aero Maintenance Inc · Vancouver, WAN80350Lobstein Michael R · Belleville, ILN80358Holmes Howard W · Lebanon, TNN80363Corey Cathy Pike · Shelbyville, KYN80366Steranka Paul O Jr · Charleston, WVN8036NVanderhoof Chad T · Elk, WA
Back to Cessna 172M