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.
N3224SSkylane Trio Ltd · La Junta, CON3226SJones David A · Wasilla, AKN3233SVan Ness James A · Buckley, WAN3235SPollard Brent H · Wilburton, OKN3240SBenson Richard T · Bend, ORN3242SBateman Amber · Elizabeth City, NCN3248SHanson Glen W · Anchorage, AKN3252SWhite Robert E · Woodlawn, TNN3253SCobb Darrell V · Corsicana, TXN3254SAllen John C · Austerlitz, NYN3257SFelton Frank B III · Thorndale, TXN3258SRockwood Spa LLC · Houston, MON3260SAbner Aviation LLC · Advance, NCN3261SBig Island Gravity LLC · Kapaau, HIN3262SIlair LLC · Manassas, VAN3263SBynum Albert L · Gadsden, ALN3265SZehntner David R · Labelle, FLN3268SSquier Mark R · Lake Dallas, TXN3273SHepfer John E DBA · Midland, TXN3276SLewinsky Marlon · Carrollton, TXN3277SBayless Smoky · Coronado, CAN3278SStrong Brian S · Southport, NCN3281SWright Flyers Club · Huber Heights, OHN3282SWest Thomas Edward · Watsonville, CAN3285SCastro Manny H · Tucson, AZN3288SEpple William E · Roggen, CON3289SDouble Lazy H LLC · Delta, CON3291SRegistration Pending · Highland, ILRegistration pendingN3296SBeekman Steven J · Stephenson, MIN3298SHolloway Cody L · Belle Plaine, KSN3299SS V Aeronautics LLC · Afton, WYN3373SWestern Metal Products LLC · Ellensburg, WAN3401SSonntag Robert Dennis · Volant, PAN3405SStutz Aaron M · Weed, CAN3407SWeaver Jason Andrew · Germantown, TNN3410SDurtschi Jay W · Franklin, IDN3411SHorseshoe 182 LLC · Dickinson, NDN3412SBanks Ramona C · Huntsville, ALN3413SFly Buddies LLC · Tucson, AZN3415SLehrkamp Michael C · Caputa, SDFirst renewal noticeN3416SClancey Joseph A · Wake Forest, NCN3418SSaxton Elton P · Oklahoma City, OKN3422SLanders James F Jr · Mesa, AZN3423SSchroeder Matt T · Riverside, CAN3424SPickering Heavy Hauling · Fort Lupton, CON3425SHoulihan John D · Wasco, CAN3427SNovember Sierra LLC · Lake Havasu City, AZN3430SBlue Skai Aviators LLC · Lawton, OKN3433SKah Gretchen Wendel · San Francisco, CAN3434SDawsey Carl E · Long Beach, MS
Back to Cessna 182G