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.
N3253PBishop Steven R · Bountiful, UTN325JLOstry James A · Bruno, NEN3272XJenzano John · Kennett Square, PAN327DDTraylor Robert C · Tucson, AZN327MKKlem Michael J · New Braintree, MAN3283SWall Dewey E · Norfolk, VAN3284AAnderson Donnald P · Mount Morris, MIN3296WPuller Glen D · Dixon, MON3301MSchmidt Jeffrey E · Waupun, WIN3314Koberg Lance L · Dallas, GAN3315Wells Gary S · Union Mills, NCN335CDKees Jackie D · Lake Jackson, TXN335PTRound Trip Lc · Elkhart, KSN338DWWhite Darrell W · Spencer, INN339PGCopeland Lance A · Jacksonville, ARN339TTKindschi Michael S · Mazomanie, WIN345JPPatterson Jeffrey D · Mishawaka, INN345RCAnderson John J · Whitesville, KYN347DDGillen John C · Delta, OHN3503LHanson Curtis J · Peyton, COFirst renewal noticeN3504NMchenry Wallace · Genoa, WIN3506BVolk Jason J · Pembina, NDN35080Kiever Robert P III · Summerland Key, FLN350DBMarkow James D · Clayton, DEN35118Pfeifle Michael R · Washougal, WAN35125Unger Brian R · New Baltimore, MIN3513CGuthrie Donald G · Marion, INN3513DWerren Carroll E · Concord, NHN3514NGutelius James B · Milton, PAN35152Nordel Stephen D · Gardena, CAN35153Kielar Richard W · Riverton, UTN3519TDale Keith T · Beaver Dam, KYN3520KYankowiak Tom J · Cook, MNN3525SHoffman Robert L · Merrill, IAN352ABSantini Robert A · Stewartsville, NJN353HHLoeffelholz John R · Yukon, OKN354SCBryant Randy C · Cherryvale, KSN3552VHamlton Nathan B · China Spring, TXN355BRRose Carl W · Gainesville, FLN3569FMunger Christopher M · Watertown, MAN357AFFrost Alonzo L · Hazel Green, ALN360PCMeadow Justin L · Blanket, TXN361TWPoleski Martin L · Ballwin, MON362SSonger Linda L · Mckinney, TXN363FHAdcock Gary S · Doddridge, ARN366DNYanke Scott H · Ferryville, WIN366LMDomenech-Perez Carlos A · Quebradillas, PRN368DBScollon John D · Rio Rancho, NMN369CSStreit Freddie H · Vernon, TXN369GHBaker David C · San Ysidro, CA
Back to Rotax 582SER