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 ('2075816')
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 ('2075816')
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.
N7373SSkiles Jere K · Narvon, PAN7374QBrooks Lee · Miami, FLN7375QFort Sam Houston Flying Club · San Antonio, TXN7375SSutherland Joan Ellen · Richmond, VAN7376NSale Reported · Bloomburg, TXSale reportedN7376QThompson Christopher John · Odessa, FLN7377QKnights Aviation LLC · Cuyahoga Falls, OHN7378NWhitmarsh Stephen C · Marysville, CAN7379QVolair Lineas Aereas Del Caribe Sa LLC · Tamarac, FLN7379S818 Flyers LLC · La Crescenta, CAN737MDThorn Williard F · Canton, MAN7380NWolverton Engineering Inc · Collins, MSN7381NHorizon Enterprises LLC · Kalispell, MTN7381QBooth Sean A · Auburn, CAN7382NTerracon Pipelines Inc · Healdsburg, CAN7382QOsterman Michael A · Maplewood, MNN7384SPluemer Steven W · Los Lunas, NMN7386NVincent Elridge J · Abbeville, LAN7387NMorgan Sheilds Aircraft LLC · Katy, TXN7388NFerguson James S · Adrian, MON7388QJohnson Timothy R · Aguila, AZN7390QChesmore Daniel R · Ten Mile, TNN7394NPritchett Randal M · Kingfisher, OKN7396NAd Astra Aviation Services LLC · Saline, MIN7396QBoling Justin · Eureka, MON7397QCabral Jesse J · Whitethorn, CAN7399QStc Group LLC · Westlake Village, CAN73GLG & N Enterprises LLC · Sparks, NVN73GMPrice Roger Paul · Punta Gorda, FLN73PRegistered aircraftN7404NFmy Aviationllc · Fort Myers, FLN7412QTrostad Kari L · Minnetrista, MNN7413QMccullough Alfonzo F · Aurora, CON7416QRobin Alan Olmstead · Yuma, AZN7422QZimmer Steven F · Lacrosse, WAN7423NHolland Reggie K · Dillsboro, INN7425NSteiner Stephen Trustee · Redding, CAN7427QDavidson William F · Port Orange, FLN7428NHawthorn Transportation LLC · North Sioux City, SDN7429NWholly Guacamole LLC · Steamboat Springs, CON742DC5c Aviation Inc · Boise City, OKN7430QFlying Paws Aviation LLC · Louisville, CON7431NWe Fly LLC · Fort Payne, ALN7432NJensen David F · Clarks Grove, MNN7432QWatkins Daniel L · Fuquay Varina, NCN7434QD'Ambrosia Louis E · Chardon, OHN7435NPieretti George L · Sacramento, CAN7436QStefanowicz Chester J · Baltimore, MDN7437NSundance Aero LLC · Mertzon, TXN7438NMockler Sarah Margaret · Awendaw, SC
Back to Cessna 182P