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 ('2072718')
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 ('2072718')
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.
N1990XCedar Valley Lumber Company LLC · Fullerton, NEN1991XTree-O LLC · Daphne, ALN1992XBush Richard A · Mccall, IDN1994XCovenant Flyers LLC · Sharpsburg, GAN1998XBlue Sky Powers N1998x LLC · Dover, DEN1999XThompson Justin · Duncan Falls, OHN2004XCovetous Inc · Fallbrook, CAN2005XTurnmire Jeffry B · Knoxville, TNN2010XHutchinson Darrold K Trustee · Hingham, MTN2011XSalem Ricky L · Burnet, TXN2013XEec Group LLC · Kalispell, MTN2014XTashjian Kirk G · Stanwood, WAN2015XAircraft Trade Group LLC · Scandia, MNN2016XSmith James A · Lyle, WAN2017XJensen Timothy L · Hudson, WIN2018XMahan Multimedia LLC · Lexington, KYN2019XZarracina Robert · Stillwater, MNN2020XCullman Aviation Inc · Cullman, ALN2023XZim Sim LLC · Charleston, SCN2024XMahaney Nicholas · Tahlequah, OKN2026XGonzales Alvin S · Mount Prospect, ILN2027XArchuleta Tommy L Jr · Bermuda Dunes, CAN2028XWalker James H III · Anderson, SCN2032XAiv Con Inc · Charlevoix, MIN2033XPeterson Todd D · Bonfield, ILN2034XMcfadden Paul · Fallon, NVN2037XDavis Russell C · Greenbrae, CAN2040XBas Part Sales LLC · Greeley, CON2044XNc Flyers LLC · Raleigh, NCN2045XOsborne David A · Helotes, TXN2049XTaylor Stephen A · Benton, KSN2050XWhite Levi E · Joliet, MTN2053XGolden Richard J · Stafford, VAN2054XVoz Garth O · Gonzales, TXN2055XMartin Robert L Jr · Havana, ILN2056XWhite Christy · Wichita, KSN2057XLewis Tommy · Winnsboro, TXN2064XCurtin Andrew J · Fernandina Beach, FLN2069XFrance Frederick M · Gales Ferry, CTN2070XNrt LLC · Maple Valley, WAN2076XStumm Robert W · Cadott, WIN2084XPrier Duncan M · Bonita Springs, FLN2085XBrian Murray J · Pekin, ILN2086XPerron Joseph R · Jasper, GAN2089XMoravitz Kim J · Turtle Lake, WIN2090XTreeline Services LLC · Grimes, IAN2091XBas Part Sales LLC · Greeley, CON2095XMiller Michael D · Goffstown, NHN2097XSouth Carolina Forestry Commission · Columbia, SCN2098XKuefler Michael J · Saint Ignatius, MT
Back to Cessna 182H