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.
N1712Sky Knights Flight Club · Thousand Oaks, CAFirst renewal noticeN171AWBell Anthony S · Quitman, TXN172ASPurtell Gordon J · Lisle, ILN175ABLensegrav Leslie · Meadow, SDN176MBAviata Aircraft LLC · Sterling Heights, MIN1775CSadler Jerry L II · Fairbanks, AKN178KHBerrios Ramon · Drummonds, TNN1790HMalzer Mark A · Turtle Lake, NDN17FDGuiter Charles · Merritt Island, FLN1807HStranberg Keith P · Oregon, ILN184ABSellers Robert L · Live Oak, FLN18901Stowe David C · Wilmington, ILN1903YHarbert Bruce L · Frankston, TXN195MWWhitney Michael W · Lincoln, MEN2018QMurphy Robert L · Morristown, TNN2029NGeiger Randal L · Fort White, FLN20331Lambright James K · Elmdale, KSN20569Shively Allen E · Wasilla, AKN211RRGarcia Caraballo Alberto · Mayaguez, PRN214WBBarody Robert J · Queensbury, NYN2195YThuss Michael G · Two Rivers, WIN222FPSale Reported · Rome, GASale reported, canceledN223CPiasecki Paul T · Rogers, ARN224RLLefebvre Richard Joseph-Louis · Rcho Sta Marg, CAFirst renewal noticeN227RMoldovan Michael E · Tampa, FLN228DRMurphy Charles Patrick · Martinez, GAN228GTFrontera Francisco · San Sebastian, PRN2301NMaraschiello Anthony Vito · Woburn, MAN2327WWahl Matthew E · Pittsford, NYN233ENNash Dennis J · Prairie City, SDN2352SRibordy Daniel L · Kinsman, ILN24083Reyling Jacob J · Frankfort, ILN2418FVosters Marvin N · Appleton, WIN241DJKaytes Barry P · Browns Mills, NJN241WLHall Ricky E · Canastota, NYN2481JMay John D · Austin, ARFirst renewal noticeN2487BCraddock Dan D Jr · Brighton, TNN2487EMcelheny Steven G · Oak Lawn, ILN248DCRamsey Jason J · Odessa, TXN2492FJackson Keith M · Martinsville, VAN2492QMcquown Bruce · Sabinal, TXN2493PMackey Sean M · Traverse City, MIN2496SKahler Donald C · Schoolcraft, MIN2499CRodriguez Roberto J · Palmhurst, TXN25063Freres Michael James · Woodland Park, CON25197Registration Pending · Crestview, FLRegistration pendingN2520XJeffs Jonathan A · Kunia, HIFirst renewal noticeN2522NReichwald Brian T · De Pere, WIN2525ADunn George M III · Chicago, ILN2531GHarbuck Richard · Palmer, AK
Back to Rotax 582DCDI