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 ('55558')
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 ('55558')
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.
N7030ERayburn Douglas W · Hamilton, KSN7061LJorgensen Larry C · Randle, WAN7093TReinauer James Richard Jr · Dallas, TXN7193KHollis John D · Tracy, CAN740QHeavenbound Enterprises LLC · Johnstown, OHN75076Schnelle Dale L · Overland Park, KSN7518LChesapeake Ultralights LLC · Edgewater, MDN753CMMeyer Charles E · Monee, ILN7591AHostetler Chad S · Berryville, ARN7593ASwanson Patrick M · Omaha, NEN767JDDill Jeffrey R · Pleasant View, TNN787EEClark William A · Middlebury, INN797XSchuler Robert F · Millersburg, MIN799HGEstes William J III · Middletown, NYN800HGWilliams Eric · Miami, FLN8020UJohnson Joel T · Le Mars, IAN80225Appleby Robert K · Springfield, MON810SJHam Russell W · Dike, TXN82JLRegistration Pending · Magee, MSRegistration pendingN844SGGuinter Steven D · Dillsburg, PAN8541Johnston John H · Parkville, MON86063Osborne Dustin M · Lamar, MON8613ESmith Charles A · Perry, KSN8613JSmith Charles A · Perry, KSN88800Coffman Robert P · Cardington, OHN902PSShores Kelly W · Thayer, ILN9094UBeins Jonathon R · Lincoln, NEN9290RFaith Space LLC · Bigfork, MTN9413Bateson Matthew E · Independence, KSN942DFBailey Robert E · Groveland, FLN987JPPierce Joseph Edward · Louisburg, NCN99WXToler Cecil R · Franklin, IL
Back to Rotax 582UL