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.
N2196RStonebrink Melvin D · Wallowa, ORN2198ROlson Darryld A · Buckley, WAN21EWRountree Christopher B · Burbank, CAN21LDCaswell Bruce · Charleston, WVN2302RNitz Michael W · Volente, TXN2303RRosborough Todd D · Medford, ORN2305RTorres Fernando A · Derwood, MDN2306RRenshaw Laurence A · Cave Creek, AZN2307RSugiono Oliver C · San Marino, CAN2310RMccarty Brian Keith · Huntsville, TXN2312REagy Gregory L · Boise, IDN2313RBlackman David M Trustee · Pacifica, CAN2314RWilson George L · Hideaway, TXN2318RJigamian Geoffrey T · Temecula, CAN2322RSink Lendon V · Lexington, NCN2324RKincheloe Ralph H · Jerome, IDN2325RLucky Catch LLC · Canton, MSN2326RSinger Don · Oxnard, CAN2329RRivers Andrew · Midland Park, NJN2331RSawicki Michael T · Midland, MIN2339RStephens Grant A · Palmer, AKN2340RBrandt Phillip A · Boyd, TXN2342RFrisco Enterprises Inc · Califon, NJN2347RDillon John C · Flagstaff, AZN2348RMiller Robert S · Laurel Springs, NCN2351RBrockman Robert L · Christoval, TXN2352RElkhorn Aviation LLC · Mandan, NDN2354RCarter Bradford J · Rockland, MEN2355RLima Mike Inc · Ham Lake, MNN2356RBledsoe Charles J · Jackson, GAN2359RTide City Air LLC · Germantown, TNN2362RBarone Christian · Stratham, NHN2363RVertikle Enterprises LLC · Cheyenne, WYN2364RRegistered aircraftN2371RBudell Stacey M · Caldwell, IDN2380RReep Nicolas K · Yakima, WAN2387RLeroux Fernand Dean · Lagrange, GAN2389RB2fh Ltd · Allentown, NJN2392RHarvey Aaron C · Bandon, ORN2395RSweitzer Derrick L · Stewartstown, PAN2396RLucky Aviation LLC · Cincinnati, OHN2397RElevate Air LLC · Sandy, UTN2400RJenkins Clayton S · Brock, TXN2401RSky182 LLC · Eugene, ORN2402RSmith Porter Allen · Aztec, NMN2403RDuck Dennis H · Jefferson City, TNN2406RSale Reported · Lincoln, NESale reportedN2411RLowery Jerry W · Cartersville, GAN2415RRegistered aircraftN2417RJohary Aviation Inc · Apopka, FL
Back to Cessna 182G