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 engine_model_code IN ('55556')
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 engine_model_code IN ('55556')
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.
N179LSReid Steven O · Northumberland, PAN1829LPittsburgh Aircraft Sales & Leasing Inc · Wilmington, DEFirst renewal noticeN183JDDuty Justin B · Waco, TXN183SCTice James D · Gold Canyon, AZN1840CStamps Jeffery Scott · Mounds, OKN1840HSisson William H · Allegan, MIN186MBBorthwick Michael · Stanwood, WAN1880HNieves Jorge L · Dunnellon, FLN188MBHuckaby Charles E Jr · Caryville, TNN1890CJohnson Troy A · Greenfield, MON18LBCloudbase Engineering LLC · Glendale, CAN18SUMolina Angel Humberto · Sahuarita, AZFirst renewal noticeN190DBBucy Dale A · Palmetto, FLN190ZXSiegenthaler John C · Holland Patent, NYN191WRFlorida Hang Gliding Inc · Orlando, FLN192PDDeland Research Corp · Deland, FLN192WRFlorida Hang Gliding Inc · Orlando, FLN193ABAnderson Craig D · Forestburg, SDN193WRFlorida Hang Gliding Inc · Orlando, FLN194JRTurknett Brandon S · Conway, ARN1950RBaugh Caleb · Carthage, MON1955ECorporon Robert M · Chico, CAN195RBickers Kevin T · Tehachapi, CAN196ABDavis David M · Clearfield, UTN196MWEverett Gary L · Aurora, MEN196WRFlorida Hang Gliding Inc · Orlando, FLN197WRFlorida Hang Gliding Inc · Orlando, FLN198WRFlorida Hang Gliding Inc · Orlando, FLN1998AFurgeson Dale G · Edinburg, ILN199KFCamper James B · Lakeland, FLN2002GWilliams Brian R · Sparta, TNN2014WBuckingham Darryl L · Cleburne, TXN2018YTatkovsky John · New Tripoli, PAN202JCLudwig Brent D · Olathe, KSN203JGMcvay Kurt K · Arlington, WAN2040FBertovich Frank M · Centerville, TXN20419Bess James V · Sequim, WAN20438Bruffett Chris L · Jasper, MON2071JBalloon Gregg R · West Wareham, MAN207DCCzeh Daniel T · Cato, NYN2080HClark Timothy B · Ogden, IAN20860Giesler Richard B · Twin Falls, IDN208RSJanssen Reinhard · Dayton, NVN208WGGrusik William A · Union, MEN209ABHorton Brian R · Chillicothe, MON2106RCook Kenny R · Abilene, KSN212GLCarvan Matthew R · Independence, MON2169White Ralph · Canyon Lake, TXN216BHYocum William J · Scranton, ARN216DWWood David F · Bristol, TN
Back to Rotax 582SER