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 ('2110102')
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 ('2110102')
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.
N2126EBrown Courd · Warr Acres, OKN2130EMarshman Robert M · Murfreesboro, TNN2132EMann Thomas A · Ford, WAN2141ERobertson Mark A Trustee · Keosauqua, IAN2142ECadotte Anthony J · Minnetonka, MNN2144EWatry Gary J · Malone, WIN2146EBallow Gregg R · West Wareham, MAN2153ERespecki Daniel R · Vassar, MIN2163EParrish Brian K · Southlake, TXN2172EAdams George · Franklin, INN2177ESean P Mcgrath · Plano, TXN2178EHarrell M Clyde Jr · Bainbridge, GAN2179EWeyer Sharon M · Edgewater, FLN2189EJones Duane R · New Carlisle, OHN2192EBeihoffer Daniel J · Tower, MNN2193EGrey Ben · Hyde Park, NYN2205EWager Douglas K · Mobridge, SDFirst renewal noticeN2216EHicks James R · San Antonio, TXN2227ECawley Lamb Elizabeth J · Buckley, WAN2237EEdwards Edgar · Fort Smith, ARFirst renewal noticeN223RGSale Reported · Conway, ARSale reportedN2241ELefeve Douglas H · Cedar Park, TXN2247ELeibenguth Ronald E · Palmerton, PAN224LBlissfield Flight Club Inc · Blissfield, MIN2261EStebbins Scott A · Elk, WAN2264EGauthier Peter J · Woodburn, ORN2266EOtto David L · Lacey, WAN2272EGulf Airbatics Ltd · Jennings, LAN2274EBallou Gregg R · West Wareham, MAN2275EKircher Wayne E · Yorba Linda, CAN2277EYost David M · Applegate, CAN2281EMedina Angel O · Pasadena, CAN2287ESchober David · Union Bridge, MDN2288ECarlson Tatum D · Lake Bronson, MNN2301ELegler Michael D DBA · Webster, MNN2307EAbel Brandon R · Henderson, NVN230EELumley William B · Delray Beach, FLN2315EMorton Dennis D DBA · La Harpe, ILN2316EDaviss Joseph A · Sylacauga, ALN2317EDoell John Homer · Elfrida, AZN2318EAir Giblinski LLC · Sedgwick, KSN2327EZubeck Robert E · Emery, SDN2334ESale Reported · Warren, OHSale reportedN2337EWhidby Richard L · N Myrtle Beach, SCN2338EAllen Timothy J · East Kingston, NHN2343EFly Greater Breezewood LLC · Clearville, PAN2344EPage Wayne Byron · Rochelle, ILN2353ERotenberry Paul G · Mount Juliet, TNN2363EBlack Jeffrey P · Hartselle, ALN2367ERegistration Pending · Mannington, WVRegistration pending
Back to Aeronca 7AC