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.
N64530Dazi Inc · Wilmington, DEN64532Wings Over Texas Holdins LLC · Denton, TXN64535Panair Flying Club Inc · Miami, FLN64537Peters Ronald J · Fountain Hills, AZN64538Crittenden Grace · San Luis Obispo, CAN64541Corbett William C · Havelock, NCN64542American Patrols Inc · Midland, TXN64543Rcr Aviation LLC · Mansfield, OHN64901Gwaviation Consulting LLC · Woodstock, GAN64919Hawk III Flyers Club · Republic, PAN649ESFlymore Aviation LLC · Philadelphia, PAN64EFHampton Flying Services LLC · Portsmouth, NHN64SSGriffiths Jon · Carson City, NVN6508HBkb Inc · Newport, MIN6509HSale Reported · Benton, KSSale reportedN6512HOrganization Of Black Aerospace Professionals Inc · Olive Branch, MSN6524HCole Keith D Trustee · Celina, TXN652RHTwohy David S · Osceola, WIN6530HWagons West LLC · Myrtle Beach, SCN6537HRivers Robert A · Oxford, NCN6539HAbove The Haze LLC · San Lorenzo, CAN6542HOwens Flight Training LLC · Lafayette, LAN6545HAmerican Patrols Inc · Midland, TXN6556HRyco LLC · Lusk, WYN6557HRiverside Flight Academy LLC · Riverside, CAN6570HBritten Air LLC · Natchitoches, LAN6571HHentges Dave · Canby, MNN6577HRegistered aircraftN6586HOracle Aviation LLC · Omaha, NEN6588HSwanson David L · Rolling Meadows, ILN658LMLge Flying Club Inc · Marietta, GAN65KDNorthwest Wings LLC · Hillsboro, ORN6601HCanby Pilots Club Inc · Canby, MNN6602HOver The Mountain Aviation LLC · Calera, ALN6613H6613 H Ltd · Wilmington, DEN6616HBurke Anthony · Poughkeepsie, NYN6617HNorth Franklin County Flying Club · North Lawrence, NYN6624HSakata Lissa C · Falls Church, VAN663RTRaiders Tigers Flying Club Inc DBA · Houston, TXN6640HSolis Aviation LLC · Carroll, OHN6646HIowa Great Lakes Flyers Inc · Cheyenne, WYN6654HBertapelle Joseph R · Derby, KSN6660HBarr Air Patrol LLC · Mesquite, TXN666MHBenson Shawn E · Rock Hill, SCN6670HMcinnis Jody · Hillman, MIN6671PLunn Frank Paul III · Chatham, NHN6672HDavenport Thomas C · Buchanan Dam, TXN6677HPeterson Robert E · Richland, WAN6693HSwithenbank Leonard Co-Trustee · Fort Bragg, CAN6695MRegistration Pending · Sheridan, WYRegistration pending
Back to Cessna 172M