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 ('2071826')
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 ('2071826')
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.
N6811GPearce Douglas S · Belleville, MIN6812GJannus Air Inc · Tampa, FLN6819GJ & J Holdings LLC · Warren, MIN6820GJensen Eric Gunnar · Ogden Dunes, INN6821GMueller Carla I · Lexington, SCN6822GKnot Enough Airspeed LLC · Oshkosh, WIN6825GRhodes Bruce A · Santa Cruz, CAN6826GStar Voyages LLC · Kissimmee, FLN6827GBrooks Jeffrey C · Bridgeton, NJN682ADDuncan Brian · Indianapolis, INN6832GAeronautical Technical Service Inc · Collierville, TNN6834GRoberts Edwin G · Lake Wales, FLN6836GRegistration Pending · Highland, UTRegistration pendingN6840GMiller Robert L · Tecumseh, MIN6843GTracey Corp · Midland, VAN6850GVoorheis Patrica D · Casa Grande, AZN6854GUniverse LLC · Prospect, KYN6857GDuran Alexander · Holbrook, NYN6875GStevenson Mark Frank · Anthem, AZN6876GMyers Russell E · Happy Jack, AZN6883GSchroeder David C · Norfolk, NEN6887GMassuet Nancy O · Sunrise, FLN6889GKozlowski James · Zeeland, MIN6892GDetroit Public Schools Community District · Detroit, MIN6893GHuesgen Paul M · Villa Ridge, MON6897GLewis Derek P · Hurricane, UTN68WMHoward Group LLC · Bunnlevel, NCN6903GShipe Jacqueline M · Louisville, TNN6907GMaguire Dennis · Delaware, OHN6909GStemper Peter L · Madison, SDN6912G98x LLC · Caddo Mills, TXN6913GAshland Jeffrey C · Spirit Lake, IAN6919GSeats Frank R · Bristol, VAN6921GWard Michael J · Carnesville, GAN6926GWelling Michael J · Milltown, WIN6931GWoody Eric · Candler, NCN6932GRonald O Holcomb LLC · Republic, MIN6933GAltomari Richard · Pittsburgh, PAN6938GRf Aviation LLC · Owensboro, KYN6943GBoydston Tony C · El Paso, TXN6947GLin-Aero LLC · Conway, ARN6948GJbar Ranch LLC · Downey, IDN6949GTillstrom Gary A · Memphis, TNN6951GHernandez Alfonso · Garland, TXN6953GVidal Miguel · Novi, MIN6955GExecutive Aircraft International Inc · Bolivar, TNN6956GR & B Helicopters Inc · Calhoun, GAN6958GScoskie Keith E · Van, TXN6962GGill Robert S · Anchorage, AKN6966GHotsenpiller Larry E · Sedalia, MO
Back to Cessna 150L