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 ('2072706')
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 ('2072706')
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.
N7155ETriple F Flying Club Inc · Indianapolis, INN7156ELittle Bird Airways LLC · Hamburg, NYN7157ECowell Norman B III · Lomita, CAN7158EHall Craig A · Corvallis, MTN7160EKenyon Larry H · Grafton, OHN7161ERegistration Pending · Thomasville, NCRegistration pendingN7166ESutton Aircraft Salvage LLC · Palmer, AKN7168ERampton Curtis D · Reno, NVN7170EMcknight Thomas N · Fredericksburg, TXN7171EPhillips John · Vernal, UTN7172EGibson James T · Brookhaven, MSN7173EMcpherson David R · Sturgis, SDN7174ESuazo Tito L · Glendale, AZN7176EBuggy Bath Unlimited LLC · Sheridan, WYN7179EHoem Shawn M · Emmett, IDN7180EPrice William T III · Chuckey, TNN7182EShoreline Consulting Inc · Bryan, TXN7185ENenadic John P · Camas, WAN7188EWashick Timothy J · South Lake Tahoe, CAN7190EBrown Hector M · Glenwood Springs, CON7192EBailey Jackson Thomas · Willow Springs, MON7193EErickson Kirk E · Lake Havasu City, AZN7196EMile High Aviation LLC · Pahrump, NVN7198EAcute Holdings LLC · Jenks, OKN7199EHornor Kent A · Oak Creek, CON7200EAircraft Structural Repair Inc · Hamilton, MTN7202EAlbertson James M · Westville, FLN7208ECrockett Donald R · Artesia, NMN7215EPatton James Jay · Sequim, WAN7216EZeus Air Inc · Wilmington, DEN7217ERomo Daryl · Anchorage, AKN7218ERice Ross H · Moab, UTN7221EMuller Farm And Ranch · Grenora, NDN7224EHowenstein John G · Roseville, CAN7226EKinnebrew John · Adkins, TXN7229ECreighton Richard L · Cincinnati, OHN722BSAnstrand Charles J · Boise, IDN7232ESitta Donald C · Farmington, NMN7238EStevenson Bill · Sunrise Beach, TXN7242ES S Farms Of Freeborn County Inc · Albert Lea, MNN7244ETomsheck Matthew E · Seville, OHN7245EWheeler Chad L Personal Representative · Arco, IDN7247EStrong Brian S · Southport, NCN7248ESchutt Patrick M · Kingsville, MON7255EValley Pilots Flying Club Inc · Martinez, CAN7259EWiley Jerry Lynn · Mission, TXN7262EStrough Jacob L · Twin Falls, IDN7267EHigh Range Aviation Inc · Gooding, IDN7268EBoyer Steven L · Wooster, OHN7269EFerguson Douglas M · Mount Vernon, OR
Back to Cessna 182B