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.
N6967GHuddleston Edward I · Oaktown, INN6970GOstrem John C · Stillwater, MNN6971GParks Rodney A · Vero Beach, FLN6975G61hv LLC · Shady Shores, TXN6978GSaia Mark · Oak Harbor, WAN6979GWestall Ken L · Santa Maria, CAN6980GSamudio Lazaro III · Wildomar, CAN6982GBedford Cutter G · Bremerton, WAN6983GGoemmel Steven J · Airway Heights, WAN6984GCoffel Alexander · Meridian, IDN6985GBustamante Wilton F · Whitsett, NCN6991GMid South Aircraft Sales Inc · Glencoe, ALN6992GMosch Edward C · Indialantic, FLN6998GAviation Trust Company LLC Trustee · Oklahoma City, OKN69HPHigh Performance Aircraft LLC · El Cajon, CAN7001GWhite Richard L · Pittsburgh, PAN7023GCunningham Kieran G · Newport, RIN7038GRoeder Blaine W · El Prado, NMN7039GWood Donna L · Wisconsin Dells, WIN70958Froh Samuel · North Pole, AKN7107GSkyward Aviation LLC · Westborough, MAN7118GRegistration Pending · Spruce Pine, ALRegistration pendingN7136GFairchild Natalie J · Drummond Island, MIN7138GWerenko Zandra · Cape Canaveral, FLN7153GEricson Eric · St Charles, ILN7191GHis Grace LLC · San Angelo, TXN71CPKitty Hawk Flight Training And Tours LLC · Nags Head, NCN7206GKane Gabriel · Yucaipa, CAN7223GLaze Daniel · Carson City, MIN7243SEggers Matthew O · Keller, TXN724MCSutton Aircraft Salvage LLC · Palmer, AKN7274GFlyit LLC · Washougal, WAN7279GMartin Rick · Rindge, NHN7282GDurley Randal W · Talladega, ALFirst renewal noticeN7283GPetersen Conrad H · Kenmare, NDN7286GRegistered aircraftN728LCHeath Richard · Raymondville, TXN7297GBraun Ralph H · Moreno Valley, CAN72CPGrant Henry R H · Ocracoke, NCN7303GGolden Greg J · Thurman, IAN7312GKlitzke Lucanus E · La Plata, NMN7313GBend-Over Hill Aviation LLC · Dover, DEN7322GHolt Thomas H · Griffin, GAN7372GSky Cops LLC · Midland, TXN7407GStarr Ralph H · Port Orange, FLN74150Meyer Tabatha M · Fairview, TXN7438GMcguinnis Joseph G · Scottsdale, AZN743RBBenefield Shelby · Attalla, ALN7440GJohnes Charles H · Santa Maria, CAN7451GPresto William R · Houston, PA
Back to Cessna 150L