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 ('2072706')
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 ('2072706')
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.
N2344GJones Alva L · Craig, CON2348GWright Michael Lee · Isanti, MNN2349GRegistration Pending · Buckley, WARegistration pendingN2351GBradley John · Edgewood, NMN2353GCascade Aero LLC · Scotts Mills, ORN2354GJbtg LLC · Poplar Bluff, MON2356GKajans Donald F · Reno, NVN2360GVath Edward V · Acton, CAN2361GMcmanigle Jeffrey M · Osakis, MNN2363GSawaya Mark C · Spring Valley, CAN2364GTveitnes Svein T · Whitewright, TXN2367GSahagun Salvador G · Bothell, WAN2369GPeter Travis E · Casper, WYN2370GJ H Nicklas Inc · Cartersville, GAN2372GJohnson David B · Santa Barbara, CAN2374GAirco International LLC · Everett, WAN2376GN2376g LLC · Helena, MTN2377GLutz Matthew S · Lewistown, MTN2378GStramel Matthew J · Elko, NVN2381GKittelman Thomas L · Gilbert, AZN2382GGish Joseph B · Lewiston, IDN2384GAircraft Holdings LLC · Ellensburg, WAN2387GPitsch Air Service · Grand Rapids, MIN2388GFlat Top Sheep Co · Carey, IDN2396GLee James R · Hamilton, TXN2397GHargis William J · Covina, CAN2399GJohansson Ronny · Wasilla, AKN2401GKidd Alexander P · Nashville, TNN2403GZeus Air Inc · Wilmington, DEN2405GWarren Sam A Jr · Stanwood, WAN2407GFaull James Aldo · Boise, IDN2408GEl Coyote Ranch LLC · Alzada, MTN2418GSunset Cay Orc Partners LLC · Key Largo, FLN2419GBig Sky Aviation LLC · Kapaau, HIN2425GMccune Charles · Metamora, ILN2427GMcneil Jesse M · Central, AKN2428GBackcountry Guys LLC · Prescott, AZN2429GSkydive Florida Keys Inc · Summerland Key, FLN2433GHunt George P · Kamiah, IDN2435GVoninski John R · Manlius, NYN2436GDk Futures LLC · Reno, NVN2438GWk Aviation LLC · Buffalo, SDN2439GJ+J Electric LLC · Seminole, TXN2442GRegistration Pending · King Salmon, AKRegistration pendingN2444GDurbin Brian · Lone Tree, CON2446GAcute Holdings LLC · Jenks, OKN2447GTroyer Thomas · Chickamauga, GAN2449GDimzoff Justin W · Hines, ORN2450GMathieson Erik L · Kapowsin, WAN2451GHerring Gary A · Elverson, PA
Back to Cessna 182B