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 ('2072716')
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 ('2072716')
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.
N2097RWilson Wayne D · Saratoga Springs, NYN2100RAbresch Craig G · Idaho Falls, IDN2104RRegistration Pending · Palm Beach Gardens, FLRegistration pendingN2107RDickman Steve · Anchorage, AKN2108RWard Neal Cpas Pc · Scottsdale, AZN2109RVilt Jared J · Phelan, CAN2112RKuspuk School District · Aniak, AKN2113RStrong Tower Aviation LLC · Trenton, FLN2116RS&H Aviation LLC · Myrtle, MSN2117RAlt Oliver B · Newberry, FLN2118RKopecki Carin E · Hobson, TXFirst renewal noticeN2119RAviation Boosters Inc · Sparta, NJN2120ROda Mark E · Angola, INN2121LDl Contractors Inc · Rexburg, IDN2121RDengler Phillip L · Bordentown, NJN2123RHowell William J · Incline Village, NVN2124RKokjer Kenneth J · Fairbanks, AKN2125RHogue William B Jr · Simi Valley, CAN2128RCreasey Daniel L · Arnold, MON2131RCapriccio Leasing LLC · Tigard, ORN2132RSifsof Victor G DBA · Anchorage, AKN2133RLewis Christopher S · Hancock, MIN2136RGibbens John L Trustee · Rock Springs, WYN2137RFreefall Express Inc · Gardiner, NYN2139RShaw Gregory A · West Richland, WAN2144RButterfield Stephen · Nampa, IDN214RDAardvark Aircraft LLC · Kalamazoo, MIN2151RMclelland Ronald James · Taylorville, NCN2152RRobinson Aviation LLC · Wilmington, DEN2155ROne Zero Four LLC · Germantown, TNN2156RWinfrey Walter A Trustee · Auburn, CAN2160RPaper Plane LLC · Hotchkiss, CON2161RKlemme Aviation LLC · Davenport, IAN2163RRupp Michael David · Lunenburg, MAN2165RSproket Industries Inc · Fulton, CAN2166RKrom Raymond L · Brighton, MIN2167RTake It Easy LLC · Durango, CON2168RNd Aero Solutions LLC · Bismarck, NDN2172RMitchell Gary · Huntsville, TXN2173RRegistered aircraftN2175RHolt Kristopher T · Wichita, KSN2177RCalongne Michelle H · Cypress, TXN2178R2178 Romeo LLC · Pawlet, VTN2181ROflynn Christopher M · Woodland, WAN2184RHatbox LLC · Snohomish, WAN218WSeaplane Adventures LLC · Cheyenne, WYN2191R2gl P&I LLC · El Paso, TXN2193RBig Island Gravity LLC · Kapaau, HIN2194RJacobson Aviation LLC · Hannibal, MON2195RMclean Laura A · Palmer, AK
Back to Cessna 182G