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 ('55562')
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 ('55562')
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.
N25349Hayward Stace A · Terrell, TXN25388Overholt Jamison T · Whiteville, TNN2541UDorsey James M · Brooklyn, WIN2541ZRegistration Pending · Humboldt, TNRegistration pendingN2546SCarter James L · Elsberry, MON2547RAndrew Peter M · Green Bay, WIFirst renewal noticeN2550HChicks Randall J · Bowler, WIN2560RPowlen Jay O · Kewanna, INN2561AMarquiss Steven A · Two Rivers, AKN2563ADick Ronald J · Fort Wayne, INN2567XHackl Paul D · Lake Worth, FLN2572FBailey Corinne · Giddings, TXN257XVanover Tony L · Marysville, CAN2589Maguire William J · Marshfield, WIN259KVital Patrick G · Seguin, TXN2614CSpitzer Craig A · Colton, ORN261YPMcconnell Martin · Carolina Beach, NCN2623ADawson James C · Clare, MIN2631TLanderos Edward E · Brighton, TNN2635MAlbertson Michael G · Foxhome, MNN2637MMitchell Dennis H · Santa Clara, UTN2646TNebelski Charles E · Hernando, FLN2674EBaugh Caleb · Carthage, MON2697AJohnson David W · Myrtle Beach, SCN2717PWhitney Richard B · North Brookfield, MAN2730TMasood Zahedi · Sandy Springs, GAN2756NSchneider Chris E · Flanagan, ILN2758AGohlinghorst George · Bel Air, MDN275DTGirard Louis W · Schulenburg, TXN2776RWatson Tim H · Hendersonville, TNN280TXListi John C · Jersey Village, TXN2825WPelkey Richard L · Farmington, NHN2831AOsborn John L · Goodwine, ILN2927ARudnicki Chester · Sterling Heights, MIN295ARobinson Kent A · Richardson, TXN30526Babcock Tansi M · Lowell, INN30528Poper Jack D · Rensselaer, INN3069EWenrich Harold L · Northumberland, PAN308AAGreenwood Richard N · Goldfield, NVN308SCShirley Steve L · Summertown, TNN30987Blue Glendale R Jr · Cottonwood Falls, KSN3098WMcclure Chris L · Tuscumbia, ALN30VCYoder Larry L · Sherwood, MIN3113BSchmidt Matthew F · River Falls, WIN3117YMartin Jonathan · Encinitas, CAN3120DDarden William T · Smithfield, VAN3120XGoodman Mary D · Salome, AZN312DJSalcewicz George D · Stow, OHN3130AKaminski Terry J · Kimberly, WIN3135SOlson Jesse A · Murdock, MN
Back to Rotax 582DCDI