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 ('2073704')
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 ('2073704')
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.
N2830XCollins Stanley T · Elizabethtown, KYN2834XEtown Powersports · Elizabethtown, KYN2836XWheeler Kimberly · Kent, WAN2837XAirspeed Marketing LLC · Phoenix, AZN2841XBerry Bradley A · Titusville, FLN2842XWatkins Andrew A · Newark, TXFirst renewal noticeN2846XJones John J · Fort Worth, TXN2848XZafar Umar · Oklahoma City, OKN2849XMoore Garrie William · Georgetown, TXN2850XStricker Michael L · Sherwood, ORN2856XHorn Paul M · Vacaville, CAN2862XMathews Nancy M · Englewood, TNN2864XCardinal Airways LLC · St Johns, FLN2866XFeller Gerald A · Long Beach, CAN2867XThrush Air Lc · Mason City, IAN2877XJim Doherty Trucking Inc · Sacramento, CAN2879XGregoire Louis Bernard III · Blairsville, GAN2880XGerstung Dennis R · Anchorage, AKN2883XRamano Raymond C · Napa, CAN2887XTolmachev Nikolay A · Anchorage, AKN2889XKogele Donald J · Broadus, MTN2893XOlson Philip D · Garden Plain, KSN2895XBoydn2895x LLC · Santa Cruz, CAN2898XOzment Dennis W · Palmyra, MON2900XHenslee Eric J · Grosse Ile, MIN2901XErwin Brandon · Jacksboro, TXN2903XBrowning Mcpherson Aviation LLC · Auburn, KYN2905XRudy Schmitt · Brookshire, TXN2910XTallman Richard E · Lykens, PAN2911XRobbins Donald V · Anchorage, AKN29221King Management Systems Inc · Liverpool, TXN2924XAllen Thomas L · Cedar Rapids, IAN2925XPerry Albert D · Houston, TXFirst renewal noticeN2929XKot Ronald J · Punta Gorda, FLN29307Lacroix Michael G Trustee · Shorewood, MNN2930XAero Dynamics Flying Club Inc · Mulino, ORN2931XRegistered aircraftN29320Triple G Aviation LLC · South Point, OHN29321Render Jeff · Peoria, ILN29329Hill Edward J Jr · Dover, DEN29330Rucinski Edward A · Climax, NCN29334Burger Cale L · Hampden, MEN29335Sale Reported · Lebanon, ORSale reportedN29340Hodges Michael T · Myrtle Beach, SCN29343Aeromech Incorporated · Mukilteo, WAN29344P & P Aviation LLC · Trout Run, PAN29345Bailey Daniel L · Gibsonville, NCN29350Cardinal Flyers LLC · Amherst, VAN29356Rohwer Celia · Fairbanks, AKN2935XStelzer David C · Vermilion, OH
Back to Cessna 177