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 ('2072704')
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 ('2072704')
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.
N5095DTevik Michael A · Provo, UTN5098DShepard Mark S · Malin, ORN5101DGavin Ronald A · East Helena, MTN5105DPaulsden LLC · Caldwell, IDN5106DOut Of The Blue Skydiving LLC · Parker, CON5107DHardman Lorin D · Wasilla, AKN5108DTeam Gateway LLC · Lewes, DEN5109DCaine Jennifer M · Rigby, IDN5110DBlaine Wright Inc · Polson, MTN5112DScootair LLC · Alburgh, VTN5114DCasillas Justin M · Liberty, TXN5116DRoche Patrick R · Wichita Falls, TXN5117DAndre Kashierski · Estill Springs, TNN5126DDalrymple Mike B · Salinas, CAN5129DPolatis Daniel T · Pingree, IDN5133DPalmer Ross G · Las Cruces, NMN5137DNeuschwander Raymon J · Canby, ORN5138DUrlaub James E II · Phoenix, AZN5139DEdwards A Clay · Weaverville, CAN5143DMacbeth Keith Adam · Thompson, UTN5146DAnderson Daniel S · Payson, AZN5148DNick Peak Flying LLC · Mccall, IDN5153DFree Fall Gulf LLC · La Grange, TXN5155DPritt Joseph H · Wasilla, AKN5157DPari Gabe M · Ontario, CAN5159DFleming James Daniel · Kansas City, MON5160DPatton Jay A · Hobbs, NMN5161DKnutson Wayne R · Thompson, NDN5162DRodrigues George C · Aiken, SCN5165DHull Terri L · Weirsdale, FLN5169DHomesick Angel LLC · Black Hawk, CON5170DSandford Graves M · Moberly, MON5171DFaber Elgin · Havre, MTN5177DCross Richard G · Brewster, MNN5179DBlack Daniel L · Spicewood, TXN5181DSchrick Robert B · Firth, NEN5182DJensen Rodney H · South Jordan, UTN5187DHonnold Thomas M Jr · Cascade, IDN5190DWalden James F · Willcox, AZN5192DJstream Lc · Sheridan, WYN5194DHumphries Danny · St George, UTN5196DPugsley Todd F · Albany, ORN5198DHaw LLC · Wilmington, DEN574WBDeal Timothy E · Anchorage, AKN578LWWags And Wings LLC · Sunset, LAN58182Gregory Jess R · Cottonwood, CAN5847BHart Johndale · Pagosa Springs, CON5848BOdenbrett Jeffrey E · Brighton, COFirst renewal noticeN5852BShaw David V · Colville, WAN5854BCruson James W · Spring Creek, NV
Back to Cessna 182A