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 ('2072702')
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 ('2072702')
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.
N6216ASnow Terry R · Oak Harbor, WAN6221AFlight Level Avionics & Maintenance Services LLC · Milton, FLN6222AAir Charter · Ottawa, ILN6224AAviation Of North Florida LLC · Jacksonville, FLN6225AMilpower Inc · Nampa, IDN6226ADaggett Aviation Inc · Daggett, CAN6227AAllur Air LLC · Minnetrista, MNN6229ABrown Jennifer L · Vancouver, WAN6232APeters Duane A · Anchorage, AKN6233AAgl Aero LLC · Mckinney, TXN6234ALiu Weston B · Brookline, NHN6235AStewart Madison F Co Personal Representative · Broken Arrow, OKN6239APara Plane Aviation Inc · Thomasboro, ILN6241AAerial Messages Leasing Co · Longwood, FLN6243AKolar James P · Mendota Heights, MNN6244ASioholm William N Jr · Wallingford, CTN6245ABackcountry Guys LLC · Prescott, AZN6246AWirt James L · Goldsby, OKN6253APiper David L · Peshastin, WAN6255ABennett Dennis Lane Jr · Hastings, MIN6257ASmolinski Michael E · Withams, VAN6261AAviation Of North Florida LLC · Jacksonville, FLN6263AHusbands Jason · Belen, NMN6264ATurley Joseph D · Mcalester, OKN6268AHenshaw Jon R · Miami, FLN6269ABubs Tub LLC · San Angelo, TXN6271AAshley Edward A · San Antonio, TXN6273AStreufert Colton P · Boise, IDN6275ABrown Thomas C · Littlefield, TXN6277AElliott Aviation LLC · Bliss, IDN6281APowell Alvin · Caldwell, IDN6282ASullivan Christopher M · Harvey, ARN6283AMuffett John D · Moore, IDN6285AMiller Scott D · Elsie, MIN6287ARespess William Wallace III · Summerland Key, FLN6288AMartin Joshua Keith · Rifle, CON6296ABarber Michael L · Igo, CAN6298AExec Air Of Naples · Naples, FLN6300AByrne Theodore · Cannon Falls, MNN6301AJohnson James A · Fairbanks, AKN6305AMissouri Aviation Inc · Leeton, MON6308ABravo Hotel LLC · Lewes, DEN6312AJosephine Air LLC · Castle Rock, WAN6314AGarletts Frank · Jackson, MSN6315APerkins Larry L · Wildomar, CAN6318AElliott Dave P · Boulder, CON6319BAtarah LLC · Tucson, AZN631SLee Grant L · Dallas, TXN6323AGlick Brady M · Colorado Springs, CON6324ADiaz Anthony V · Salinas, CA
Back to Cessna 182