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 ('2072624')
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 ('2072624')
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.
N64183Chiappe Glenn R · Lago Vista, TXN64205Mulligan George G Trustee · Friday Harbor, WAN64211Miller Paul F · Whitefish, MTN64251Gilliland Brothers Drayage LLC · Farmington, UTN64257Lutes Ralph E · Shipshewana, INN64337Clearwater Airco LLC · Anchorage, AKN64382Roost Leasing LLC · Sturgis, MIN64426Brook Trout Air LLC · Cle Elum, WAN644FMHolby Eric · Breckenridge, CON64529Stallion 51 Corp · Kissimmee, FLN65992Holseberg Aviation LLC · Ridgeville, SCN65999Vaughn Thomas N · Shallowater, TXN65RHHall Robert · Rapid City, SDN66021Mcgraw Leasing LLC · Sitka, AKN66033Schwarz Wesley E · Ovalo, TXN66034Shaffer Mark N · Ocala, FLN66040Sierra Auto Recycling Inc · Ridgecrest, CAN66041Wof Investments LLC · Dover, DEN66128Mcgowan Walter R · Gold Hill, ORN66156Mount Crillon LLC · Juneau, AKN66182Naples Seaplane Adventures LLC · Denmark, MEN66186Rybak David J Sr · Lino Lakes, MNN66202Biggerstaff Connie J · Stanford, MTN66226St Cyr Shane · Plattsburgh, NYN66237Agri-Systems Aviation LLC · Litchfield, MNN66266Cleveland Monica L · Penn Yan, NYN66289Brine William H · Edgartown, MAN66321Swenson Donald C · Stanchfield, MNN66449Lindvig Thomas H · Williston, NDN66471Nelson Travis E · Richland, MTN66566Aircraft Structural Repair Inc · Hamilton, MTN66597Barlow Brent · Mills, WYN66618Trigg Eric R · Erie, CON66629Schelhorn Timothy · Nampa, IDN66643Parrott Chad D · Paris, TXN66691Maroney Lorraine J · Anchorage, AKN66735Ryan Adrian · Anchorage, AKN66764Cuttler Lloyd · Carabaset Vly, MEN66765Kalba Shaun B · Pleasant Valley, NYN6792RKenley Fredrick C · Palmer, AKN679RMMattox Richard A · Friday Harbor, WAN68PMGraham Michael Trustee · Arbor Vitae, WIN6TKPritchard James A III · Maysville, GAN711RMMoore Roger · Louisville, KYN715CN9lu Aviation LLC · Wilmington, DEFirst renewal noticeN715WBRichardson Clay W · Ozona, TXN717SWHannibal Lee W · Rathdrum, IDN71CNAnderson Thomas R · Seattle, WAN71MHSchultz Engineered Products Inc · Neptune, NJN755HBBrown William Henry · Ravenna, TX
Back to Cessna 180K