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.
N314CFFlora Craig S · Longmont, CON31539Kennedy James P · Twin Falls, IDN31554Reese Danielle A · Columbus, OHN31596Kelly Cody T · Paris, TXN3168FWeinberg Scott Glenn · Bloomfield Hills, MIN3169FMcmillan Dennis C · Carthage, TXN3169KIsherwood Ian · Silverton, ORN316GWWeber John H · Leesburg, FLN3172NKrause Dave A · Red Bud, ILN31765Orin Christopher A · Monmouth, ORN31778Gough Clarke A · Amelia Court House, VAN323ABBolstad Anthony J · South Padre Island, TXN3265KSherrick Stephen R · West Mansfield, OHN326TTTucker Timothy E · Chapel Hill, TNN3277DDavenport Jerry · Sheffield, TXN3280TRidder Jerome J · Leoti, KSN3285JSale Reported · Churchville, MDSale reportedN328JCBorders David R · Hendersonville, NCN328RMMartin James R · Bradenton, FLN328SMBlitch Joseph F · Saint Marys, OHN3294DBjornstad James O · Mcville, NDN337PGCarkenord Aric L · Pharr, TXN341RPPrange Richard L · Merrill, WIN3502ZBaugh Israel A · Carthage, MON3503RZelasko Edward P · Lansing, ILN3506FRowe Jasen M · Sumter, SCFirst renewal noticeN3507GStockie David M · Alderson, WVN35137Grant Evan C · Bandon, ORN3513QChristenson Phillip · Suring, WIN3515GDunn Larry W · Benton City, MON3515QJess Alvie E · Arthur, ILN35161Braatz Russell G · Lake City, MNN3519LFelbush Monte · Abilene, KSN3519MLarson Philip F · Bennett, WIN35222Dunn Kyle H · Eddyville, KYN35228Errahali Younes J · Tallahassee, FLN3522CGraham Michael G · Central Islip, NYN35235Besser Mark M · Cambridge, MNN3523FDe Bruin Richard L · Oskaloosa, IAN35251Wieck Dean P · Bentonville, VAN3525DTesluck Timothy S · Sandusky, MIN358KPHollon Robert E · Eau Claire, WIN3624SYoder Mark A · Goshen, INN373WDebarbieris Carl · Houston, TXN373YPSvabic Shimo · Byron Center, MIN3754SKowalis Kurt A · Tinley Park, ILN3828FMiller Robert G · Elgin, ILN383CMSaxton Craig J · Kirkland, WAN383WBSwartzlander Craig M · Sunbury, PAN3862VHartman Jean-Christophe S · Fishers, IN
Back to Rotax 582DCDI