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 ('2072730')
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 ('2072730')
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.
N54626Continental Title Trust LLC Trustee · Wichita, KSN555SCBlack Raven LLC · Monroe, LAN559DBRundle James R · Sparks, NVN5621XDiorio Joseph · Murrieta, CAN567JBHarper Alli B · Joaquin, TXN59MJSweatt Greg · Cochise, AZN615ESCampanell Garrett · Leesburg, VAN622FEPeninsula Aero Technology Inc · Kenai, AKN669SRCabot Scott R · Cross Plains, WIN6868LJohnson Gregory L · Orange, CAN69ACKendel Stephen George · Colbert, WAN703ZSibert Gerald R · Tacoma, WAN7062Carvagno Lawrence · Trinity, ALN706PREvoaviation LLC · Watkinsville, GAN709RHHope Ronald F · Clemmons, NCN70VHBlue Sky Flyers LLC · Fairfield, NJN731AALandis Lloyd B · Ardmore, OKN74MBRoland Cary T · Moscow, KSN766EETomaszewski John E · Oceanside, CAN7810Danger Zone Aviation LLC · Ham Lake, MNN808BCMahanawai Lele LLC · Honolulu, HIN81708Adventist World Aviation Inc · Wilson, NCN81CMBrothers Holdings LLC · Waterford, MIN8225HLout James M · Jasper, TXN82HSAdventist World Aviation · Wilson, NCN8516MSealane LLC · Burlingame, CAN88717Copp Mathew J · Cumberland, MEN889ESDalissandro Michael Douglas · Hampton, NHN88PKGray Farms Inc · Albany, ORN8907GInfinity Aviation · Pine Island, MNN8915GFerdon Richard P Trustee · Fort Mohave, AZN8916GSorenson Robert H · Forsyth, MTN8931GJordan Robert Nelson · Oakdale, LAN8934GCallender Andrew T · Howard City, MIN8935GHagouel Yehouda · Reseda, CAN8937GRussin William A · Gurnee, ILN8938GTenore William H · Lyons, CON8939GIms Aviation LLC · Kawkawlin, MIN8940GCapps Christopher N · Austin, TXN8942GSale Reported · Stevensville, MTSale reported, canceledN8943GTruyaert Ivan R Jr · New Carlisle, INN8944GSagra Nw LLC · Ronan, MTN8948GWilbur-Ellis Co · Salinas, CAN8949GChuckanut Flying Club Inc · Bellingham, WAN8951GThrash Helen · Pelahatchie, MSN8953GAirfleet Solutions LLC · Newark, DEN8963GThompson Cory D · Holly, CON8964GSandige David J · Mckinleyville, CAN8966GBerti Robert C · Diamond Springs, CAN8967GHill Cannon E · West Richland, WAFirst renewal notice
Back to Cessna 182N