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.
N2099XGreen Glen A · Willits, CAN2129DLoadholtz Heath T · Watford City, NDN2182RFoxley Brothers · Platte, SDN229CN229c LLC · Holt, MOFirst renewal noticeN2301XPetritsch Ryan · Warrington, PAN2302XSedation Vacation Pllc · Dalton, GAN2304XAbel Van A · Wichita, KSN2305XSale Reported · Rock Hill, SCSale reportedN2307XCornwall Brady Evan M · Shelton, WAN2312XCain James W · Big Rapids, MIN2314XFlight Resources LLC · Monroe, GAN2315XParker Ronald Lewis · Melissa, TXN2317XSproul Wendell C · Hermon, MEN2324XSchutjet Dennis · Clear Lake, IAN2326XFerris Elden L · Vancouver, WAN2330XKeller Ronald B · Bosque Farms, NMN2333XHjr Aviation LLC · Reno, NVN2339XPetet David G · Orofino, IDN2341XYale LLC · Watford City, NDN2342XKinsella Joseph R · Jackson, WYN2347XRegistered aircraftN2348XChessman H Ross · Erie, CON2354XNorth Coast Aeronautical LLC · Cleveland, OHN2355XVan Every Jason E · Cleburne, TXN2357XScavera Kevin · Madras, ORN2359XHarker Charles R · Suwanee, GAN2362XFort Scott Family Medicine Pa · Fort Scott, KSN2363XShort Joe · Clintwood, VAN2364XElkhorn Aviation LLC · Norfolk, NEN2368XD C T LLC · Wallace, IDN2371XCouch Sue A · Dewy Rose, GAN2372XRegistered aircraftN2374XMorrison Aircraft · Harrisburg, ARN2375XBaldwin Todd K · Prescott Valley, AZN2377XBieker Tor M · Hood River, ORN2379XK Fortner LLC · San Marcos, TXN2380XGaller Mary D Trustee · Elysian, MNN2381XCooper Scott J · Fellows, CAN2382XRolleston Moreton M III · Canton, GAN2383XComo Aviation LLC · South Weymouth, MAN2384XHill James P · Eagle Point, ORN2388XSeiler Richard · Bozeman, MTN2392XSmm Leasing LLC · Camp Verde, AZN2394XPierson Daniel · Kalispell, MTN2395XEdwards Keith D · Olathe, KSN2397XDow Todd J · Wasilla, AKN2398XPerry Brian J · Stuart, FLN23CCulver Marc D · Anchorage, AKN2402XTeeter Ralph R · Caldwell, IDN2408XWyatt David · Las Vegas, NV
Back to Cessna 182H