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.
N85036Lafleur Peter R · Eunice, LAN8504QAndreotta Robert M · Fulton, NYN8504YBaugh Dan A · Carthage, MON8506HRiebel Randal P · Iola, KSN8509VShoemaker James O'Farrell · Millington, TNN852GKKeith Grady V · Clinton, ARN8545MVermilyer Lewis N Jr · New Carlisle, INN8545XGustavison Josh A · Alma, MIN8547TWeesner David F · Apache Junction, AZN8554QEckertson Wayne J · Eugene, ORN855CFFlowers Charles L · Yelm, WAN855KJRenouf Dale A · Casco, MIN8578KLongoria Rodrigo B · Corydon, INN8586GPassa Larry J · Drayton, NDN85DBDahl-Bredine Chris T · El Prado, NMN86018Wilson Charles Daniel · Parkersburg, WVFirst renewal noticeN8604AClarke David P · Bellingham, WAN8607AOliveira Kevin M · Monmouth, MEN8607RCruz Gilberto · Hialeah, FLN8608BAndrea Gregory A · Peoria, AZN8608CHamilton Roger D · Walkerton, INN8611EBeckman Alan C · Lexington, KYN8611NWimer Timothy S · Roanoke, VAN8612XBrown Robert J Jr · Nekoosa, WIN8612YYoder Dallas K · Mechanicsburg, OHN8615AGoldring Bruce · Jacksonville, FLN8615GYoder David L · London, OHN866XLPetrowske Mike A · Garden Grove, CAN870WSSebesta Waldo E · Somerville, TXN8830RSale Reported · Sun Valley, NVSale reportedN8977QHouston Robert · Murray, KYN897EANieves Carlos · Isabela, PRN8990ZStom Michael D · Box Elder, SDN899RAInocencio Thomas J · Grand Forks, NDN900FPGriesman Scott W Jr · Phoenix, AZN90109Radle Steven H · Baker City, ORN9021AIrish Gerald W · Livermore, CAN90279Sepulveda Maria M · Lancaster, PAN9032HBrombach Joseph · White Pine, TNN9032YStrong James H · Fall River Mills, CAN9035FHowell Aviation LLC · Orlando, FLN9065CCerny Stanley · Leonidas, MIN90768Miller Gilbert H · Richmond, KYN90796Werren Carroll E · Concord, NHN9080AKonechne Jerry L · Kimball, SDN9080GShortis Kevin R · Petersham, MAN908PCJung Jerre A · Littleton, CON91087Rosenboom Steven R · Pomeroy, IAN911GRHooper Jerry D · Knoxville, TNN911JGAnderson Joey A · Taylorsville, UT
Back to Rotax 582SER