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 ('21101PK')
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 ('21101PK')
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.
N7594FPierschbacher Clifton A · Marysville, WAN771MRSmith Nathan · Palmer, AKN8057HTrevor Bruce B Jr · Green Bay, WIN8304VHorning Air LLC · Cresbard, SDN8318VVetter Brent E · Helena, MTN8323VToczek Keith E · Yankton, SDN8330VJensen Carla J · Pingree, IDN8365VJarvis Stormy A · Anchorage, AKN8368VRare Air LLC · Forsyth, MTN8380VMaxwell Frank R · Fairbanks, AKN856KWMurphy Michael J · Mendota Heights, MNN8CKPresley Danny K · Homer, AKN9004LThoman Mark C · Jacksonville, NCN9013LBarbee Lisa · Dallas, TXN9015LMalone Aaron E · Wasilla, AKN9018LJones Dwight D · Anchorage, AKN9023LLammers David T · Bonney Lake, WAN9029LMarracino Services LLC · Deland, FLN9031LSanderlin Doulgas C · Wasilla, AKN9032LJohnson Robert W · Buffalo, SDN9033LBickmore David L · Bay City, MIN9036LWhitmer Charles W · Fairbanks, AKN9052LOlson Ronnie E · Palmer, AKN9060LShank Paul L · Gaithersburg, MDN9071LWolfley Jody K · Mountain Home, IDN9109LYellowbird LLC · Lititz, PAN9113LZimin Carl E · Naknek, AKN9114LKeller Crop Surveillance LLC · Jonesboro, ARN9116LShowers Of Blessings LLC · Fredericktown, MON9117LWillkris Aviation Services LLC · Smithfield, VAN9118LDavis Brett M · Madison, MEN9119LPiercy Ronald S · Moses Lake, WAN9126LHager David L · Barney, NDN9134LSipes Greg A · North Pole, AKN9151LCerrato Michael J · Dublin, OHN9600SHargrove Tom R · Coffeyville, KSN9640SFrancis James E · King City, CAN9642STaylor Jonathan K II · Granbury, TXN9643STurner Nathan D · Nenana, AKFirst renewal noticeN9657SWhite Wayne A · Scenic, SDN9667SJones Larry C · Clovis, NMN9686SAirpro Aviation LLC · Cross Lake Twp, MEN9698SLindgren Darrell A · Lake Nebagamon, WIN995JDCarrol Mears Farms Inc · Newport, AR
Back to Champion 7GCBC