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 ('2072726')
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 ('2072726')
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.
N42693Paul D Barkhurst Pc · San Antonio, TXN42694Jaffa Bruce E · Moose Pass, AKN42698Bruch Stein · Randolph, MNN42704White Dog I LLC · Bend, ORN42705Henry James A · Fresno, CAN42707Management Assistance Group LLC · Hamilton, NJN42712Adams William Kelly · Tulia, TXN42713Prater Bobby D · Grand Ledge, MIN42714Crouch Jeffrey Lane Sr · Rockingham, NCN42715Coleman Robert B · San Francisco, CAN42718Circle K Bar LLC · Ardmore, OKN42725Tepper Jeremy A · Vail, AZN42732Wampole David R · Miami, FLN42742Still Russell F · Cumming, GAN42748Crowe Tanner L · Anchorage, AKN42754Shade Donald S · Big Bear City, CAN42758Carver Steven R · Scottsville, KYN42763Vf 126 Aviation LLC · Chicago, ILN427653 B Farms Inc · Pinetown, NCN42766Jessee Robert A · Winter Haven, FLN42768Horn Terry D · Sharpsburg, GAN42770Barthelette Kenneth E · Pawleys Island, SCN42777Cantwell Patrick W · San Francisco, CAN42792Baxter Adam W D · Anchorage, AKN42801Aas LLC · Ovid, MIN42804N42804 LLC · Brush, CON42818Cleveland Jeffrey Allen Trustee · Indian Trail, NCN42820Cordobesa Aviation LLC · Belgrade, MTN42823Acs Products Co · Lake Havasu City, AZN42826Aero Elite Inc · Wilmington, DEN42831Shuff James S II · Victor, WVN42849Moonrise Soaring Inc · Wilmington, DEN42851Emmons Steven · Russellville, ARN42852Fisch Kurt D · Riverside, CAN42855Wojteczko Jason A · Derby, KSN42858Younggren James H · Hallock, MNN42865Skylane Partners LLC · Duvall, WAN42871Registered aircraftN42874Kloker Daniel E · Owasso, OKN42875Bowes Tyler D · Fremont, OHN42876Norcal Flight Center LLC · Lincoln, CAN42877Allain Patrick C · Brusly, LAN42887Bratlien Michael D · Aurora, CON42888Ahigian Craig S · Laguna Niguel, CAN4288PMooradian Edward M · Fowler, CAN42893Registration Pending · El Paso, TXRegistration pendingN42894Comal Aero Inc · Schertz, TXN42898Perera Austin L · Barnstable, MAN42899Smith Charles Max · Canon City, CON42907Albion Telephone Co · Albion, ID
Back to Cessna 182L