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 ('2072704')
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 ('2072704')
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.
N2064GGarcia Edward O · Hereford, AZN2065GZach Matthew L · Oconomowoc, WIN2066GLatofski-Jeffries Gustavo Enrique · Mcallen, TXN2067GYeager Hal J · Winterset, IAN2070GAerobus LLC · Des Moines, IAN2071GGroarke Michael J · Marion, MTN2072GMccullough Russell O · Carson, CAN2073GShepard Brothers LLC · Columbia, MSN2075GReeves David G · Salmon, IDN2076GOrman Rodger S · Murphys, CAN2077GSharp Robert M Trustee · Jenks, OKN2078GCasaus Santos · Rio Rancho, NMN2079GStaiano Salvatore G · Flemington, NJN2082GKennedy Daniel M · Boise, IDN2084GFlying Farmers LLC · Hills, MNN2085GBackcountry Guys LLC · Prescott, AZN2086GHigh Country Aces LLC · Cove, ARN2087GTate Frederic H S DBA · Marfa, TXN2090GLight Chop LLC · Lexington Park, MDN2092GUllrich Sandy J · Haskell, OKN2093GNew Herschel Dudley Jr · Savannah, GAN2095GRegistration Pending · Bozeman, MTRegistration pendingN2099GHilten Robert W · Columbus, MTN20DEEbright Sean E · Hasty, CON2100GTpa Skylane LLC · Asheville, NCN2102GPool Lori A · Cody, WYN2110GBurns John A · Granite Shoals, TXN2115GBroeske Ian D · Windsor, CAN2118GKohlhase Amy M · Anchorage, AKN2119GReese Gerald D · Brooten, MNN2120GSouthern Arizona Balloons Inc · Tucson, AZN2121GSutton Aircraft Salvage LLC · Palmer, AKN2123GCasten Scot R · Vernonia, ORN2124GSilicz Alexander Nicholas · Shafter, CAN2126GSmith Jonathan R · Waxhaw, NCN2128GBeckhoff Michael A · Casper, WYN2133GPrice Bradley E · Sacramento, CAN2136GCulver Deborah M · Anchorage, AKN2139GSoarmates LLC · Missoula, MTN2140GBoger Malcolm L · Dickens, TXN2141GFreiheit Larry · Clinton, MON2145GGraham William F III · North Wilkesboro, NCN2148GMissildine Ronald E Trustee · Simi Valley, CAN2149GBay Darren J · Springville, CAN2151GLigons Michael J · Fredericktown, MON2156GBenson John Wesley Jr · Tecumseh, MIN2157GAviation Bravo Corporation LLC · Palm Coast, FLN2159GKirchoff Kevin B · Millington, TNN2162GOdiorne Bruce Lamar II · Durango, CON2165GStanley Aviation LLC · Stanley, ND
Back to Cessna 182A