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.
N11402Mcdowell Charles R II · South Charleston, WVN11405Cornelius Steven E · Wasilla, AKN11407Harrop Brian · Mesa, AZN11409Cambium International Inc · Cary, NCN11410South Florida Helicopters Inc · Indiantown, FLN11416Woodward Stephen W · Westfield, NYN11430De Alwis Godalle W · Riverside, CAN11433Jedi Flight Training LLC · Boerne, TXN11442Burkholder Donald R · Kent, OHN11452Schatz Michael J · Myerstown, PAN11454Wausau Flying Service Inc · Wausau, WIN11460Kalmar Peter · Suquamish, WAN11479Lucky Duck Aviation LLC · Palm City, FLN11485Foster Harold · Natchitoches, LAN11488Cooker Keith P · Greenville, SCN11491Jamieson Donald R · Condon, ORN11492Mccroan James H · Altha, FLN11493Wajih Al Habbal · Simi Valley, CAN1149911499 LLC · Oklahoma City, OKN11501Erickson Kirk E · Warroad, MNN11507Strickland Jed B · Bald Knob, ARN1150LNida Kevin R · Santa Paula, CAN11510Falls Aero Inc · Great Falls, MTN11513Erickson Tristan Scott · Port Townsend, WAN11514Kickstart Aviation LLC · Mayfield, KYN11517Grier Robert M · Deland, FLN11519Kap Title Inc · Tucker, GAN1151BOrtiz Daniel · Edinburg, TXN11527Red Oak Commuter LLC · Red Oak, IAN11528Streeter Derek · Guilford, CTN11529Registration Pending · Mattituck, NYRegistration pendingN11531Ireland Lois Trustee · Herndon, VAN11533Neal Robert J · Martinsville, INN11534Litzau Melissa · Lake Lillian, MNN11538Fallon James R · Chestnut Hill, MAN11540Eddleston Ryan · Winter Haven, FLN11546De Souza Alex Henrique · Newark, NJN11552Dunn Ashley L · Mc Alpin, FLN11554Groux Robert E Jr · Spring, TXN11558Cwi Air Motive Inc · Grant Park, ILN11561Marsh John E · Washington, DCN11563Hunnewell Aviation Services Inc · La Crescent, MNN11569Cornejo Jose Valente · Scottsdale, AZN11570Wilson Steven J · Elkton, KYN11571Sale Reported · Spokane, WASale reportedN11573Airfleet Solutions LLC · Newark, DEN11577Tre Aviation Corp · Wilmington, DEN11587Stark Avionics LLC · Panama City, FLN11589Harbert Gary J II · Newville, ALFirst renewal noticeN11590Ramaswamy Gautam · Clearwater, FL
Back to Cessna 150L